Re: Getting comments from schema using SQL
check out the pg_description system catalog:
http://www.postgresql.org/docs/8.2/static/catalog-pg-description.html
-------------------------------------------------------------
http://www.elsasoft.org
Show quoted text
On Jan 29, 2:40 pm, "Timasmith" <timasm...@hotmail.com> wrote:
Hi,
What query can I run to get the comments on my table columns using
SQL?thanks
Tim
Import Notes
Reply to msg id not found: 1170106820.400101.3870@a34g2000cwb.googlegroups.comReference msg id not found: 1170106820.400101.3870@a34g2000cwb.googlegroups.com
google@jessehersch.fastmail.fm writes:
On Jan 29, 2:40 pm, "Timasmith" <timasm...@hotmail.com> wrote:
What query can I run to get the comments on my table columns using
SQL?
check out the pg_description system catalog:
http://www.postgresql.org/docs/8.2/static/catalog-pg-description.html
Also see obj_description() and friends, which are basically wrappers
for queries on that catalog:
http://www.postgresql.org/docs/8.2/static/functions-info.html#FUNCTIONS-INFO-COMMENT-TABLE
regards, tom lane