|
Look at the SQL in the PG Admin III
project source code base. It’s non-trivial SQL to collect all
the information about a table. From: pgsql-general-owner@xxxxxxxxxxxxxx
[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On
Behalf Of Ken Tozier 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 |
