<fontfamily><param>Arial</param>I recently stumbled upon the system
catalog functions here
"http://www.postgresql.org/docs/7.4/static/catalogs.html" and see that
it's easy to get a list of all databases and relatively easy to get a
list of tables, but there doesn't seem to be any built in method for
retrieving a table definition. The best I could come up with would be
to do a select something like this:
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? Better yet, is there an easier way
to get at this metadata?
Thanks for any help,
Ken</fontfamily>
I recently stumbled upon the system catalog functions here
"http://www.postgresql.org/docs/7.4/static/catalogs.html" and see that
it's easy to get a list of all databases and relatively easy to get a
list of tables, but there doesn't seem to be any built in method for
retrieving a table definition. The best I could come up with would be
to do a select something like this:
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? Better yet, is there an easier way to get at
this metadata?
Thanks for any help,
Ken