Re: Reverse-engineering table creation statements

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 <compuguruchrisbarnes(at)hotmail(dot)com>

> 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
>
> ------------------------------
> Less clicking: Hotmail access on the new MSN homepage.<http://go.microsoft.com/?linkid=9677398>
>