Home > mailing lists

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

From	Sofer, Yuval
Subject	how do I get table DDL from psql (not from pg_dump)
Date	February 27, 2008 07:50:25
Msg-id	BE67D1149BBD5746984545ED91F702E0BD4AE3@hou-ex-02.adprod.bmc.com Whole thread Raw
Responses	Re: how do I get table DDL from psql (not from pg_dump) Re: how do I get table DDL from psql (not from pg_dump)
List	pgsql-sql

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?

Please help

Thanks

Yuval Sofer
BMC Software
CTM&D Business Unit

DBA Team
972-52-4286-282
yuval_sofer@bmc.com

From: "Markus Bertheau"
Date: 27 February 2008, 05:44:04
Subject: Re: Function returns error (view)

From: "A. Kretschmer"
Date: 27 February 2008, 08:19:25
Subject: Re: how do I get table DDL from psql (not from pg_dump)