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

[Sofer, Yuval]

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
[EMAIL PROTECTED]