SQL-Dump and refertial Integrity
| От | Thomas Woehlke |
|---|---|
| Тема | SQL-Dump and refertial Integrity |
| Дата | |
| Msg-id | 3CBAD196.B64848F0@ESC-Electronics.de обсуждение |
| Ответ на | Re: Synchronizing databases ("Josh Berkus" <josh@agliodbs.com>) |
| Ответы |
Re: SQL-Dump and refertial Integrity
Re: SQL-Dump and refertial Integrity |
| Список | 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 по дате отправления: