Copy command and duplicate items (Support Replace?)

From: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
To: Postgresql General List <pgsql-general(at)postgresql(dot)org>
Subject: Copy command and duplicate items (Support Replace?)
Date: 2007-08-14 02:50:33
Message-ID: 1187059833.23507.51.camel@neuromancer.home.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Caduto 2007-08-14 03:00:45 Re: Postgresql INSERT speed (how to improve performance)?
Previous Message Lim Berger 2007-08-14 02:47:39 Re: "Out of memory" errors..