| 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 |
| Thread: | |
| 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 | Date | Subject | |
|---|---|---|---|
| Next Message | Frank Bax | 2008-02-27 15:23:28 | Re: how do I get table DDL from psql (not from pg_dump) |
| Previous Message | Sofer, Yuval | 2008-02-27 11:22:33 | how do I get table DDL from psql (not from pg_dump) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Stark | 2008-02-27 14:04:43 | Re: REFERENCES and INHERITS restrictions? |
| Previous Message | Sofer, Yuval | 2008-02-27 11:22:33 | how do I get table DDL from psql (not from pg_dump) |