SQL-Dump and refertial Integrity - Mailing list pgsql-novice

From Thomas Woehlke
Subject SQL-Dump and refertial Integrity
Date
Msg-id 3CBAD196.B64848F0@ESC-Electronics.de
Whole thread Raw
In response to Re: Synchronizing databases  ("Josh Berkus" <josh@agliodbs.com>)
Responses Re: SQL-Dump and refertial Integrity
Re: SQL-Dump and refertial Integrity
List pgsql-novice
Hi @All!

I have a problem on dumping a database:

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.

Are there any known solutions or a workaround?

I would greatly appreciate receiving an helping answer even if this
question is very newbie-like.

Thank You

Thomas

pgsql-novice by date:

Previous
From: Bartus Levente
Date:
Subject: writing to file
Next
From: "cristi"
Date:
Subject: Date format