On Fri, 22 Nov 2002, Alex Zavalin wrote:
> Hello,
>
> Is there a simpler way of getting a PostgreSQL database structure than
> reading system catalogs pg_tables, pg_attributes, pg_class, pg_type,
> pg_index etc.? I need to get information about tables, attributes,
> data types, primary and foreign keys.
The simple answer, uh, sorta, using psql's \ commands. The long answer is
to take the code that psql's \ commands use and make a view out of them.
I.e. do 'psel -E database'
then '\d tablename'
Then take the sql statements and make views out of them.