Postgres Pro
Downloads
Home   >   mailing lists

Re: Query DDL Comments? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Query DDL Comments?
Date
Msg-id 16188.1266959478@sss.pgh.pa.us
Whole thread Raw
In response to Query DDL Comments?  (P <user2037@live.com>)
List pgsql-admin
Tree view 
P <user2037@live.com> writes:
> Is there a way to query the DDL comments for tables or databases?

Well, there's psql's \dd, or you could use obj_description and related
functions, or you could look directly at the pg_description and
pg_shdescription catalogs.

            regards, tom lane

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Sharing /etc/passwd with PostgreSQL
Next
From: "Net Tree Inc."
Date:
Subject: Re: how do I do dump and restore without bugging with constraint?