Skip site navigation (1) Skip section navigation (2)

Re: [despammed] copy from file and overwrite existing

From: Mattes Sarcander <mtsrc(at)systemausfall(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [despammed] copy from file and overwrite existing
Date: 2005-06-27 15:45:19
Message-ID: 20050627174519.65d1199a@carnivore.local (view raw or flat)
Thread:
Lists: pgsql-novice
Andreas Kretschmer <akretschmer(at)despammed(dot)com> wrote:

> > I want to import data from a csv file into an existing, non-empty
> > table. My problem is the fact that I get an "ERROR:  duplicate key
> > violates unique constraint", because, as psql correctly grumbles,
> > some entries are already inside the tables. I would like to
> > overwrite these existing entries, as the data from the csv files is
> > newer.
> 
> I suggest, use a separate import-table to copy the file in this table.
> After you can work with usual SQL to delete old Records in the
> destination table and insert the new records.

Is there a way to automate this? The table is quite big, I expect some
few hundred duplicate entries.

In response to

Responses

pgsql-novice by date

Next:From: Bruno Wolff IIIDate: 2005-06-27 16:03:55
Subject: Re: [despammed] copy from file and overwrite existing
Previous:From: Celia McInnisDate: 2005-06-27 15:02:16
Subject: Transactions within plpgsql functions?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group