Postgres Pro
Downloads
Home   >   mailing lists

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

From Sofer, Yuval
Subject how do I get table DDL from psql (not from pg_dump)
Date
Msg-id BE67D1149BBD5746984545ED91F702E0BD4ADE@hou-ex-02.adprod.bmc.com
Whole thread Raw
Responses Re: how do I get table DDL from psql (not from pg_dump)  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-admin
Tree view

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@bmc.com

 

pgsql-admin by date:

Previous
From: "Markus Bertheau"
Date:
Subject: Re: Pgsql 8.2.5 Installation
Next
From: Andrew Sullivan
Date:
Subject: Re: how do I get table DDL from psql (not from pg_dump)