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 [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
