Re: [HACKERS] Getting comments from schema using SQL

[google]

check out the pg_description system catalog:

http://www.postgresql.org/docs/8.2/static/catalog-pg-description.html

-
http://www.elsasoft.org

On Jan 29, 2:40 pm, Timasmith [EMAIL PROTECTED] wrote:
 Hi,

 What query can I run to get the comments on my table columns using
 SQL?

 thanks

 Tim


---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org

Re: [HACKERS] Getting comments from schema using SQL

[Tom Lane]

[EMAIL PROTECTED] writes:
 On Jan 29, 2:40 pm, Timasmith [EMAIL PROTECTED] 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

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate