Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group