subject:"\[HACKERS\] function to display ddl"

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

[HACKERS] function to display ddl

2010-02-14 Thread Little, Douglas

Hi, Is there a PG command or fuction that will return table ddl? Thanks Doug Little Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide 500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741 douglas.lit...@orbitz.com