Re: Data Dictionary generator?

From: David Fetter <david(at)fetter(dot)org>
To: Patrick Hatcher <PHatcher(at)macys(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Data Dictionary generator?
Date: 2005-11-03 01:49:42
Message-ID: 20051103014942.GF29465@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Nov 02, 2005 at 03:39:24PM -0800, Patrick Hatcher wrote:
>
>
> 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?

You could use pg_dump -s to get the schema, or in psql \d by itself
gets you everything :)

Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-11-03 02:38:05 Re: Changing ids conflicting with serial values?
Previous Message Steven Brown 2005-11-03 01:00:48 Changing ids conflicting with serial values?