| 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: | Whole Thread | Raw Message | 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) |