database structure

From: Alex Zavalin <a-l-x(at)mail(dot)od(dot)ua>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: database structure
Date: 2002-11-22 17:44:43
Message-ID: 16932242091.20021122194443@mail.od.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks.

postgres_autodoc & dia are good tools.

--
Aleksey mailto:a-l-x(at)mail(dot)od(dot)ua

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2002-11-22 18:00:17 Re: VARCHAR truncation
Previous Message Jon Swinth 2002-11-22 17:39:19 Unwanted Log Entries