Re: Data Dictionary generator?

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@connx.co
             m>                                                         To
                                       "Patrick Hatcher"
             11/02/2005 03:45          <PHatcher@macys.com>,
             PM                        <pgsql-general@postgresql.org>
                                                                        cc

                                                                   Subject
                                       RE: [GENERAL] Data Dictionary
                                       generator?










PostgreSQL has Information Schema

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Patrick Hatcher
> Sent: Wednesday, November 02, 2005 3:39 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] 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