Re: [HACKERS] function to display ddl

2010-02-14 Thread Ross J. Reedstrom
On Sun, Feb 14, 2010 at 05:08:05PM +0100, Yeb Havinga wrote: > Little, Douglas wrote: > > > >Hi, > > > > > > > >Is there a PG command or fuction that will return table ddl? > > > If you just want the definition,in psql type \d tablename. > To dump ddl the pg_dump with proper arguments can dump jus

Re: [HACKERS] function to display ddl

2010-02-14 Thread Yeb Havinga
Little, Douglas wrote: Hi, Is there a PG command or fuction that will return table ddl? If you just want the definition,in psql type \d tablename. To dump ddl the pg_dump with proper arguments can dump just the ddl of a single table. (see pg_dump --help) I'm not aware of a command or f