describe command for

Is there a postgres sql command/function that will display an object ddl?

I know of the psql metacharacters, but don’t know how I’d submit from a non-psql client like sqldbx.

I see that pgadmin generates a query and then formats into a ddl statement,  but this seems like a lot of work for something that I would expect to be part of the command set.

Thanks

Doug Little

Sr. Data Warehouse Architect | Business Intelligence Architecture | Orbitz Worldwide

500 W. Madison, Suite 1000  Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741

Douglas.Little@orbitz.com

   orbitz.com | ebookers.com | hotelclub.com | cheaptickets.com | ratestogo.com | asiahotels.com