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@fetter.org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!