Thank you.
"select * From information_schema.columns where table_schema = 'public' and
table_name = 'mdc_products'
order by ordinal_position;"
Thanks again.
Patrick Hatcher
"Dann Corbit"
<DCorbit@xxxxxxxx
m> To
"Patrick Hatcher"
11/02/2005 03:45 <PHatcher@xxxxxxxxx>,
PM <pgsql-general@xxxxxxxxxxxxxx>
cc
Subject
RE: Data Dictionary
generator?
PostgreSQL has Information Schema
> -----Original Message-----
> From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-
> owner@xxxxxxxxxxxxxx] On Behalf Of Patrick Hatcher
> Sent: Wednesday, November 02, 2005 3:39 PM
> To: pgsql-general@xxxxxxxxxxxxxx
> Subject: Data Dictionary generator?
>
>
>
> I need to generate a data dictionary for all my tables (name, column,
> type, etc) in my database. Is there an easy to do this without
having to
> do a \d tablename for each table?
> tia
> Patrick
>
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
