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: Frank Bax <fbax(at)sympatico(dot)ca>
- To: pgsql-sql(at)postgresql(dot)org
- Subject: Re: how do I get table DDL from psql (not from pg_dump)
- Date: Wed, 27 Feb 2008 10:23:28 -0500
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)
This command should output the SQL you need... echo '\d tablename' | psql -E
- References:
- how do I get table DDL from psql (not from pg_dump)
- From: Sofer, Yuval
- how do I get table DDL from psql (not from pg_dump)
- Prev by Date: Re: REFERENCES and INHERITS restrictions?
- Next by Date: Re: SQL standards in Mysql
- Previous by thread: Re: how do I get table DDL from psql (not from pg_dump)
- Next by thread: operator class
- Indexes: