Re: Bulkloading using COPY - ignore duplicates? - Mailing list pgsql-hackers

From Horak Daniel
Subject Re: Bulkloading using COPY - ignore duplicates?
Date
Msg-id D5637E9568BDF3499B8BB02C12B4461DD450@EXCHANGE.mmp.plzen-city.cz
Whole thread Raw
In response to Bulkloading using COPY - ignore duplicates?  (Lee Kindness <lkindness@csl.co.uk>)
List 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


pgsql-hackers by date:

Previous
From: Lee Kindness
Date:
Subject: Bulkloading using COPY - ignore duplicates?
Next
From: Jean-Michel POURE
Date:
Subject: Re: What about CREATE OR REPLACE FUNCTION?