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

From Lew
Subject Re: how do I get table DDL from psql (not from pg_dump)
Date
Msg-id nMidnQjJ-cQQC1janZ2dnUVZ_vfinZ2d@comcast.com
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
A. Kretschmer wrote:
> am  Wed, dem 27.02.2008, um  5:22:33 -0600 mailte Sofer, Yuval folgendes:
>> Hi
>>
>>
>>
>> I need to extract table DDL (create script) from database connection (using
>> sql, by retrieving system table info or by activating some pg function)
>>
>>
>>
>> Is this possible in postgres?
>
> Why not using pg_dump?
>
> You can specify with -n and -t an arbitrary table and with -s you get
> only the DDL, not the data.

The "-s" option has come up as an answer to both multi-posted instances of
this question.

--
Lew

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to reindex when unable to open relation?
Next
From: salman
Date:
Subject: Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?