On Wed, 2009-09-30 at 22:14 -0700, Jyoti Seth wrote: > I want to restore data of a single table. Before restoring the data I > disabled all the triggers and constraints on that table. I used the restore > command with --clean option so that data gets deleted from that table and > then fresh data get inserted.
--clean drops the tables, not the data. > But this is throwing error: duplicate key value violates unique constraint. > > How can I restore the data to a table that already has data? Well, you could just not use --clean, which would insert the data into existing tables. But if you have conflicting data in your tables, you need a more elaborate scheme, depending on how exactly you plan to resolve those conflicts. I think you might be a bit confused about the proper workflow with pg_dump and pg_restore and therefore are not giving us accurate information. Perhaps some more detail would help. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
