Обсуждение: Generate SQL Statements
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? -- 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@turbocorp.com www.turbocorp.com
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
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@turbocorp.com www.turbocorp.com