Reverse-engineering table creation statements

From: Thom Brown <thombrown(at)gmail(dot)com>
To: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Reverse-engineering table creation statements
Date: 2009-09-14 15:15:23
Message-ID: bddc86150909140815n26540498mb3632faa945ecaf9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Barnes 2009-09-14 15:24:42 Re: Reverse-engineering table creation statements
Previous Message Sam Mason 2009-09-14 15:12:08 Re: postgresql.key secure storage