I am looking for a way to reformat the information that is generated from
\d mytable
into SQL syntax, such that the table can be recreated with 'psql -f
mytable.sql' complete with index and constraint definitions. I can do
awk and sed commands to do this if I need to, but first wanted to check
if Pg already had tools to export the table structure (without the
data). Does it?
Also, Is there a way to export the structure of all tables at once
instead of one table at a time?
Mark