Re: database structure

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.