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

Lists: pgsql-adminpgsql-sql
From: "Sofer, Yuval" <Yuval_Sofer(at)bmc(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Cc: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>, "Amichay, Nathan" <Nathan_Amichay(at)bmc(dot)com>
Subject: how do I get table DDL from psql (not from pg_dump)
Date: 2008-02-27 11:22:33
Message-ID: BE67D1149BBD5746984545ED91F702E0BD4AE3@hou-ex-02.adprod.bmc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin pgsql-sql

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

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: how do I get table DDL from psql (not from pg_dump)
Date: 2008-02-27 12:19:11
Message-ID: 20080227121911.GE21865@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin pgsql-sql

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

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: how do I get table DDL from psql (not from pg_dump)
Date: 2008-02-27 15:23:28
Message-ID: 47C58070.2090809@sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin pgsql-sql

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

From: Lew <lew(at)lwsc(dot)ehost-services(dot)com>
To: pgsql-admin(at)postgresql(dot)org(dot)pgsql-sql(at)postgresql(dot)org
Subject: Re: how do I get table DDL from psql (not from pg_dump)
Date: 2008-02-27 16:57:49
Message-ID: nMidnQjJ-cQQC1janZ2dnUVZ_vfinZ2d@comcast.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin pgsql-sql

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