On Tuesday 03 June 2008 20:10, Steve Crawford wrote: > Terry Lee Tucker wrote: > > Greetings: > > > > I was wondering if anyone knows of a third party product that will > > generate SQL statements for creating existing tables. We have to provide > > table definition statements for out parent company. Any ideas? > > Why 3rd party? How about: > > pg_dump --schema-only -t table_name... ? > > Alternately, roll-your-own using the system tables. A good place to > start is by running psql with the --echo-queries option to see the > queries it runs "behind the scenes". You can read the queries for things > like "\d+ tablename" then modify them to suit. > > Cheers, > Steve Now why didn't I think of that :o/ Thanks for the help... -- Terry Lee Tucker Turbo's IT Manager Turbo, division of Ozburn-Hessey Logistics 2251 Jesse Jewell Pkwy NE Gainesville, GA 30501 Tel: (336) 372-6812 Fax: (336) 372-6812 Cell: (336) 404-6987 terry@xxxxxxxxxxxxx www.turbocorp.com
