From: | Andrey Mosienko <feo(at)feo(dot)org(dot)ru> |
---|---|
To: | Postgres <pgsql-general(at)postgresql(dot)org> |
Subject: | A powerful dump utility |
Date: | 2003-01-28 05:13:32 |
Message-ID: | 3E36117C.1255644B@feo.org.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello!
Is there an utility to dump PosgreSQL database with possibility to set order of
tables?
I have a situation when one of my tables was created with constraint check depending on
another table. But when I do dump, my dependable table dumped first, and then when I
restore my database it fails to load my data because of constraint check.
I wrote my own script and first I dump schema of my database and then all tables in
order I want. But dump of databse schema doesn't include:
SELECT setval ('"vl_id"', 198, true);
to setup my sequences well.
So are there any possibilities to solve my problem?
--
Best regards Andrey Feofilactovich.
e-mail: feo(at)ttn(dot)ru, feo(at)feo(dot)org(dot)ru
ICQ: 28073807
From | Date | Subject | |
---|---|---|---|
Next Message | Matt Mello | 2003-01-28 05:46:46 | Re: Indexing foreign keys |
Previous Message | Mark Aufflick | 2003-01-28 04:56:25 | Re: all backends (pg7.2.3 / redhat 7.2) die due to unexpected signal 14 (SIGALRM) |