| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
| Cc: | Oliver Kohll <oliver(at)gtwebmarque(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Retrieving a column comment |
| Date: | 2003-10-27 18:26:43 |
| Message-ID: | 933.1067279203@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> writes:
> 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.
Actually what he wants is the oid. relfilenode is not relevant to
anything except the table's disk file name.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Benoit | 2003-10-27 18:44:08 | Re: SCSI vs. IDE performance test |
| Previous Message | Ron | 2003-10-27 18:25:44 | Re: PostgreSQL with MS Query? |