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