Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: how do I get table DDL from psql (not from pg_dump)
- From: Lew <lew(at)lwsc(dot)ehost-services(dot)com>
- To: pgsql-admin(at)postgresql(dot)org(dot)pgsql-sql@postgresql.org
- Subject: Re: how do I get table DDL from psql (not from pg_dump)
- Date: Wed, 27 Feb 2008 11:57:49 -0500
- Message-id: <nMidnQjJ-cQQC1janZ2dnUVZ_vfinZ2d@comcast.com> <text/plain>
A. Kretschmer wrote:
am Wed, dem 27.02.2008, um 5:22:33 -0600 mailte Sofer, Yuval folgendes:HiI 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
- Prev by Date: Re: How to reindex when unable to open relation?
- Next by Date: Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?
- Previous by thread: Re: how do I get table DDL from psql (not from pg_dump)
- Next by thread: trouble with pg_dumpall
- Indexes: