Re: Reverse-engineering table creation statements

[Ries van Twisk <pg@xxxxxxxxxx>]

On Sep 14, 2009, at 10:27 AM, Thom Brown wrote:

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.

then call pg_dump from PHP??

or be more specific what you really need...

Ries

Thom

2009/9/14 Chris Barnes <compuguruchrisbarnes@xxxxxxxxxxx>

pg_dump --schema-only --schema=SCHEMA --table=TABLE
 
produces creation script.
 
Chris
 
http://www.postgresql.org/docs/8.0/interactive/backup.html
 

---

From: thombrown@xxxxxxxxx
Date: Mon, 14 Sep 2009 16:15:23 +0100
Subject: Reverse-engineering table creation statements
To: pgsql-general@xxxxxxxxxxxxxx

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.

regards, Ries van Twisk

-------------------------------------------------------------------------------------------------

tags: Freelance TYPO3 Glassfish JasperReports JasperETL Flex Blaze-DS WebORB PostgreSQL DB-Architect

email: ries@xxxxxxxxxxx        web:   http://www.rvantwisk.nl/    skype: callto://r.vantwisk

Phone: +1-810-476-4196    Cell: +593 9901 7694                   SIP: +1-747-690-5133