| From: | Oliver Kohll <oliver(at)gtwebmarque(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Retrieving a column comment |
| Date: | 2003-10-27 00:13:06 |
| Message-ID: | 200310270013.06851.oliver@gtwebmarque.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sunday 26 October 2003 23:03, Alvaro Herrera wrote:
> On Sun, Oct 26, 2003 at 10:02:22PM +0000, Oliver Kohll wrote:
> > I can't seem to retrieve a comment on a table column. The following copy
> > from psql should I think return a comment:
> >
> > mydatabase=> SELECT relnamespace FROM pg_class WHERE relname='car';
> > relnamespace
> > --------------
> > 2200
> > (1 row)
>
> Try using relfilenode instead of relnamespace.
Great, thanks Alvaro. The webpage I found the original code in must have been
wrong but that's it.
Oliver
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Creager | 2003-10-27 00:44:38 | Re: Question regarding Perl, DBI, and fork() |
| Previous Message | Adam Witney | 2003-10-27 00:07:52 | Re: shared memory on OS X - 7.4beta4 |