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

am Wed, dem 27.02.2008, um 5:22:33 -0600 mailte Sofer, Yuval folgendes:
> 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?

Why not using pg_dump?

You can specify with -n and -t an arbitrary table and with -s you get
only the DDL, not the data.


Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

A. Kretschmer wrote:
> am Wed, dem 27.02.2008, um 5:22:33 -0600 mailte Sofer, Yuval folgendes:
>> 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?
>
> Why not using pg_dump?
>
> You can specify with -n and -t an arbitrary table and with -s you get
> only the DDL, not the data.

The "-s" option has come up as an answer to both multi-posted instances of
this question.

--
Lew

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



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org