Обсуждение: Re: Bulkloading using COPY - ignore duplicates?

Поиск
Список
Период
Сортировка

Re: Bulkloading using COPY - ignore duplicates?

От
Horak Daniel
Дата:
> 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