Re: Bulkloading using COPY - ignore duplicates?

From: Horak Daniel <horak(at)sit(dot)plzen-city(dot)cz>
To: <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Bulkloading using COPY - ignore duplicates?
Date: 2001-10-08 12:55:49
Message-ID: D5637E9568BDF3499B8BB02C12B4461DD450@EXCHANGE.mmp.plzen-city.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> I've made some inroads towards adding 'ignore duplicates'
> functionality to PostgreSQL's COPY command. I've updated the parser
> grammar for COPY FROM to now accept:
>
> COPY [ BINARY ] table [ WITH OIDS ]
> FROM { 'filename' | stdin }
> [ [USING] DELIMITERS 'delimiter' ]
> [ WITH [NULL AS 'null string']
> [IGNORE DUPLICATES] ]

Is there any possibility that COPY could insert a row so the old row
will be discarded and a new one inserted instead the old? It could be
useful for doing replications on table with modified rows.

Dan

Browse pgsql-hackers by date

  From Date Subject
Next Message Jean-Michel POURE 2001-10-08 13:42:34 Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?
Previous Message Lee Kindness 2001-10-08 12:41:27 Bulkloading using COPY - ignore duplicates?