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

["Sofer, Yuval" <Yuval_Sofer@xxxxxxx>]

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
yuval_sofer@xxxxxxx