Re: [GENERAL] Reverse-engineering table creation statements

2009-09-14 Thread Ries van Twisk
hombr...@gmail.com Date: Mon, 14 Sep 2009 16:15:23 +0100 Subject: [GENERAL] Reverse-engineering table creation statements To: pgsql-general@postgresql.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

Re: [GENERAL] Reverse-engineering table creation statements

2009-09-14 Thread Thom Brown
arnes > pg_dump --schema-only --schema=SCHEMA --table=TABLE > > produces creation script. > > Chris > > http://www.postgresql.org/docs/8.0/interactive/backup.html > > -- > From: thombr...@gmail.com > Date: Mon, 14 Sep 2009 16:15:23 +0100 > Sub

Re: [GENERAL] Reverse-engineering table creation statements

2009-09-14 Thread Chris Barnes
pg_dump --schema-only --schema=SCHEMA --table=TABLE produces creation script. Chris http://www.postgresql.org/docs/8.0/interactive/backup.html From: thombr...@gmail.com Date: Mon, 14 Sep 2009 16:15:23 +0100 Subject: [GENERAL] Reverse-engineering table creation statements To: pgsql

[GENERAL] Reverse-engineering table creation statements

2009-09-14 Thread Thom Brown
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