Erk... I forgot to mention I don't wish to use command-line tools either. I would like to submit something as a query in PHP and get back a result with the creation script in. This is to modify some existing code which is currently only supporting MySQL.
Thom 2009/9/14 Chris Barnes <compuguruchrisbar...@hotmail.com> > 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@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 > 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 > > ------------------------------ > Less clicking: Hotmail access on the new MSN > homepage.<http://go.microsoft.com/?linkid=9677398> >
