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

[Frank Bax]

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