A. Kretschmer wrote:
am Wed, dem 27.02.2008, um 5:22:33 -0600 mailte Sofer, Yuval folgendes:HiI 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