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

Re: [despammed] copy from file and overwrite existing entries?

From: Andreas Kretschmer <akretschmer(at)despammed(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [despammed] copy from file and overwrite existing entries?
Date: 2005-06-27 14:52:11
Message-ID: 20050627145211.GA16186@webserv.wug-glas.de (view raw or flat)
Thread:
Lists: pgsql-novice
am  27.06.2005, um 16:33:59 +0200 mailte Mattes Sarcander folgendes:
> Hi,
> I am really new to database administration, so forgive me if I overlook
> something obvious ;>
> 
> 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.


Regards, Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    === 

In response to

Responses

pgsql-novice by date

Next:From: Celia McInnisDate: 2005-06-27 15:02:16
Subject: Transactions within plpgsql functions?
Previous:From: Mattes SarcanderDate: 2005-06-27 14:33:59
Subject: copy from file and overwrite existing entries?

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