On 19/12/2009 2:24 PM, Gauthier, Dave wrote:
Hi:
Are metadata creation strings, in sql form, stored anywhere in the
metadata tables?
Not AFAIK, no.
How would you handle subsequent ALTER commands and the like? What if you
ALTERed two tables in a way that could only succeed if done in a
particular order (such as creating a foreign key relationship between
two tables) ?
Have a look at pg_dump . It knows how to create appropriate DDL to
re-create particular schema objects, and can handle the various ordering
and dependency issues involved.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
