Re: SQL to get a table columns comments?

On Jan 30, 12:15 pm, "codeWarrior" <gpatn(dot)(dot)(dot)(at)hotmail(dot)com> wrote:
> SELECT
> CASE
> WHEN sfl.description IS NOT NULL THEN sfl.description
> WHEN sfl.description IS NULL THEN pa.attname::character varying
> ELSE pd.description::character varying
> END AS label
> FROM ONLY pg_class pc
> JOIN ONLY pg_attribute pa ON pc.oid = pa.attrelid AND pc.relnamespace =
> 2200::oid AND pc.reltype > 0::oid AND (pc.relkind = 'r'::"char" OR
> pc.relkind = 'c'::"char" OR pc.relkind = 'v'::"char")
> JOIN ONLY pg_type pt ON pa.atttypid = pt.oid
> LEFT JOIN ONLY pg_description pd ON pc.oid = pd.objoid AND pa.attnum =
> pd.objsubid
> LEFT JOIN sys_flex_labels sfl ON pc.oid = sfl.table_oid::oid AND
> pa.attname::character varying::text = sfl.column_name::text
> WHERE pa.attnum > 0
> ORDER BY pc.relname::character varying, pa.attnum;
>
> "Timasmith" <timasm(dot)(dot)(dot)(at)hotmail(dot)com> wrote in message
>
> news:1169949426(dot)721522(dot)117610(at)a75g2000cwd(dot)googlegroups(dot)com(dot)(dot)(dot)
>
>
>
> > Hi,
>
> > What query can I run to get the comments for my table columns.
>
> > i.e. the ones on my 8.1 database added with this command:
>
> > COMMENT ON COLUMN addresses.address_id IS 'Unique identifier for the
> > addresses table';
>
> > thanks
>
> > Tim- Hide quoted text -
>
> - Show quoted text -

I dont know about that query - I dont have sys_flex_labels but this
seems to work:

select pc.relname as tablename, pa.attname as column, pd.description
from pg_description pd, pg_class pc, pg_attribute pa
where pc.relowner = 16403
and pa.attrelid = pc.oid
and pd.objoid = pc.oid
and pd.objsubid = pa.attnum

where I had to figure out the relowner and my schema owner