Generate SQL Statements

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