> 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

Mon, 8 Oct 2001 14:55:49 +0200
=?us-ascii?Q?Horak_Daniel?= <horak@sit.plzen-city.cz>
Re: Bulkloading using COPY - ignore duplicates?