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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

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

              http://archives.postgresql.org

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux