On Sat, 27 Mar 2004, Preston A. Elder wrote:
> For example, there is nowhere in the docs that tells me "To get the OID
> of column 'y' in table 'x', do:
> SELECT atttypid FROM pg_attribute
> WHERE attrelid = (SELECT relfilenode FROM pg_class
> WHERE relname = 'x')
> AND attname = 'y'
> ". That would be an extremely useful statement to have in the docs.
This is not correct, you want
"... attrelid = (SELECT oid FROM pg_class ..."
not relfilenode.
Kris Jurka