SELECT * FROM pg_attribute WHERE attrelid=<the table oid>;
The problem I'm running into however, is that given a table name, there doesn't seem to be any way to get the table oid. Is there some function or query that does this?
I think a way to get the table oid is:
select oid from pg_class where relname=<table_name>
Ntinos Katsaros
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org