Re: Reverse-engineering table creation statements

pg_dump --schema-only --schema=SCHEMA --table=TABLE

produces creation script.

Chris

http://www.postgresql.org/docs/8.0/interactive/backup.html

From: thombrown(at)gmail(dot)com
Date: Mon, 14 Sep 2009 16:15:23 +0100
Subject: [GENERAL] Reverse-engineering table creation statements
To: pgsql-general(at)postgresql(dot)org

Is there a simple way of generating a creation statement for a table without using psql or pgAdmin. Basically I'd like to create what pgAdmin III shows in the SQL pane when you click on a table. MySQL appears to have an equivalent which is SHOW CREATE table [tablename].

Thanks

Thom

_________________________________________________________________
New: Messenger sign-in on the MSN homepage
http://go.microsoft.com/?linkid=9677403