Postgres Pro
Downloads
Home   >   mailing lists

Re: how do I get table DDL from psql (not from pg_dump) - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: how do I get table DDL from psql (not from pg_dump)
Date
Msg-id 20080227155008.GA7920@crankycanuck.ca
Whole thread Raw
In response to how do I get table DDL from psql (not from pg_dump)  ("Sofer, Yuval" <Yuval_Sofer@bmc.com>)
List pgsql-admin
Tree view 
On Wed, Feb 27, 2008 at 05:21:08AM -0600, Sofer, Yuval wrote:
> I need to extract table DDL (create script) from database connection
> (using sql, by retrieving system table info or by activating some pg
> function)

pg_dump -s does this.  See the manual for more details on the switches.

A

pgsql-admin by date:

Previous
From: "Sofer, Yuval"
Date:
Subject: how do I get table DDL from psql (not from pg_dump)
Next
From: Tom Lane
Date:
Subject: Re: How to reindex when unable to open relation?