Alvaro Herrera <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings