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" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I have a comments on tables in my database.
>
> e.g.
>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" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I have a comments on tables in my database.
>
> e.g. COMMEN
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
--
