pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedQuery DDL Comments?
2+ messages / 2 participants
[nested] [flat]
* Query DDL Comments?
@ 2010-02-23 19:52 P <user2037@live.com>
2010-02-23 21:11 ` Re: Query DDL Comments? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: P @ 2010-02-23 19:52 UTC (permalink / raw)
To: pgsql-admin
Is there a way to query the DDL comments for tables or databases?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Query DDL Comments?
2010-02-23 19:52 Query DDL Comments? P <user2037@live.com>
@ 2010-02-23 21:11 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2010-02-23 21:11 UTC (permalink / raw)
To: P <user2037@live.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-02-23 21:11 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-02-23 19:52 Query DDL Comments? P <user2037@live.com>
2010-02-23 21:11 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox