Copy command and duplicate items (Support Replace?) - Mailing list pgsql-general

From Ow Mun Heng
Subject Copy command and duplicate items (Support Replace?)
Date
Msg-id 1187059833.23507.51.camel@neuromancer.home.net
Whole thread Raw
Responses Re: Copy command and duplicate items (Support Replace?)
List pgsql-general
Hi,

Writing a script to pull data from SQL server into a flat-file (or just
piped in directly to PG using Perl DBI)

Just wondering if the copy command is able to do a replace if there are
existing data in the Db already. (This is usually in the case of updates
to specific rows and there be a timestamp indicating it has been changed
etc.)

In MySQL, the mysqlimport util has the --replace function which will
replace the data if there is any event of a duplicate.

Does PG support this?



pgsql-general by date:

Previous
From: "Lim Berger"
Date:
Subject: Re: "Out of memory" errors..
Next
From: Tony Caduto
Date:
Subject: Re: Postgresql INSERT speed (how to improve performance)?