From: | "codeWarrior" <gpatnude(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: selecting column comment |
Date: | 2006-04-27 15:18:18 |
Message-ID: | e2qn93$24qq$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)mac(dot)com> wrote in message
news:1C823FF2-FFE4-411F-B967-B9479A7A5061(at)mac(dot)com(dot)(dot)(dot)
>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
>
From | Date | Subject | |
---|---|---|---|
Next Message | G. Ralph Kuntz, MD | 2006-04-27 15:36:33 | Repost: Problem with pg_ctl register -w |
Previous Message | Aly Dharshi | 2006-04-27 15:12:53 | Re: Installing PostgreSQL on Win 2003 R2 64-bit |