Re: SQL-Dump and refertial Integrity

Thomas Woehlke <Thomas(dot)Woehlke(at)ESC-Electronics(dot)de> writes:
> If I export the Structure via pg_dump
> the table are dumped in alphabetical order, but the order violates
> the refenrential integrity of my db.

> At inserting it via psql db < db_structure.sql it throws errors and the
> database is not not correctly build on the other server. Tables are
> missing.

How old is your PG version? This problem was fixed ages ago.

If you cannot find any other way out, you'll have to edit the dump file
by hand to put the table declarations in a valid order. (It might be
best to dump schema and data separately, if the combined dump file is
too large to edit conveniently.)

regards, tom lane