Postgres Pro
Downloads
Home   >   mailing lists

Thread: selecting column comment

selecting column comment

From
Ari Kahn
Date:
I have a comments on tables in my database.

e.g. COMMENT ON TABLE my_schema.my_table IS 'Employee Information';

I know you can get comments using \d+

Is there a way to select comments?

Reason: I do a lot of perl interfaces. I find escape commands do not
work using DBI.

Thanks,
Ari

Re: selecting column comment

From
"codeWarrior"
Date:
From the system catalogs:

SELECT PC.relname, PD.description
FROM pg_catalog.pg_description PD, pg_catalog.pg_class PC
WHERE PD.objoid = PC.oid AND PD.objsubid = 0


"Ari Kahn" <resglowing@mac.com> wrote in message
news:1C823FF2-FFE4-411F-B967-B9479A7A5061@mac.com...
>I have a comments on tables in my database.
>
> e.g. COMMENT ON TABLE my_schema.my_table IS 'Employee Information';
>
> I know you can get comments using \d+
>
> Is there a way to select comments?
>
> Reason: I do a lot of perl interfaces. I find escape commands do not  work
> using DBI.
>
> Thanks,
> Ari
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>

Re: selecting column comment

From
"codeWarrior"
Date:
FWIW: From the system catalogs:

SELECT PC.relname, PD.description
FROM pg_catalog.pg_description PD, pg_catalog.pg_class PC
WHERE PD.objoid = PC.oid AND PD.objsubid = 0



"Ari Kahn" <resglowing@mac.com> wrote in message
news:1C823FF2-FFE4-411F-B967-B9479A7A5061@mac.com...
>I have a comments on tables in my database.
>
> e.g. COMMENT ON TABLE my_schema.my_table IS 'Employee Information';
>
> I know you can get comments using \d+
>
> Is there a way to select comments?
>
> Reason: I do a lot of perl interfaces. I find escape commands do not  work
> using DBI.
>
> Thanks,
> Ari
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>