Hello, Did you try to set the constraints as deferrable
i.e. begin; set constraints all deferred; ... commit; Also, you can set this by forign key , have a look on http://www.postgresql.org/docs/9.0/static/sql-createtable.html Regards ________________________________ From: jo <jose.soa...@sferacarta.com> To: pgsql-general@postgresql.org Sent: Saturday, December 22, 2012 6:29 PM Subject: [GENERAL] dump order by Hi all, I would like to know if it is possible to dump a table ordered by its primary key. Take a look at the this test table... \d test Table "public.test" Column | Type | Modifiers -----------+---------+--------------------------------------------------- id | integer | not null name | text | id_father | integer | Indexes: "test_pkey" PRIMARY KEY, btree (id) Foreign-key constraints: "test_id_father_fkey" FOREIGN KEY (id_father) REFERENCES test(id) select * from test; id | nome | id_father ----+-----------------+----------- 6 | Homer Simpson | 5 5 | Abraham Simpson | 10 | Maggie Simpson | 6 1 | Ned Flanders | 2 | Maude Flanders | 9 | Bart Simpson | 6 3 | Rod Flanders | 1 4 | Todd Flanders | 1 7 | Marge Simpson | 8 | Lisa Simpson | 6 (10 rows) I would like to dump the table with this order: COPY test (id, nome, id_father) FROM stdin; 1 Ned Flanders \N 2 Maude Flanders \N 3 Rod Flanders 1 4 Todd Flanders 1 5 Abraham Simpson \N 6 Homer Simpson 5 7 Marge Simpson \N 8 Lisa Simpson 6 9 Bart Simpson 6 10 Maggie Simpson 6 \. instead it is dumped like this: COPY test (id, note, id_father) FROM stdin; 6 Homer Simpson 5 5 Abraham Simpson \N 10 Maggie Simpson 6 1 Ned Flanders \N 2 Maude Flanders \N 9 Bart Simpson 6 3 Rod Flanders 1 4 Todd Flanders 1 7 Marge Simpson \N 8 Lisa Simpson 6 \. and I can't upload the table because the foreing keys. j -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
