how do I get table DDL from psql (not from pg_dump)

From: "Sofer, Yuval" <Yuval_Sofer(at)bmc(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: how do I get table DDL from psql (not from pg_dump)
Date: 2008-02-27 11:21:08
Message-ID: BE67D1149BBD5746984545ED91F702E0BD4ADE@hou-ex-02.adprod.bmc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Please help

Thanks

Yuval Sofer
BMC Software
CTM&D Business Unit

DBA Team
972-52-4286-282
yuval_sofer(at)bmc(dot)com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sofer, Yuval 2008-02-27 11:22:33 how do I get table DDL from psql (not from pg_dump)
Previous Message Markus Bertheau 2008-02-27 08:34:11 Re: Pgsql 8.2.5 Installation