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

From Lee Kindness
Subject Re: Bulkloading using COPY - ignore duplicates?
Date
Msg-id 15288.35898.813740.887368@elsick.csl.co.uk
Whole thread Raw
In response to Re: Bulkloading using COPY - ignore duplicates?  ("Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>)
Responses Re: Bulkloading using COPY - ignore duplicates?
List pgsql-hackers
Okay,

If I'm going to modify 'COPY INTO' to include 'ignore duplicates'
functionality it looks like I'll have to add to the COPY syntax. The
most obvious way is to add:
WITH IGNORE DUPLICATES

to the syntax. I'm going to need my hand held a bit for this! The
grammar for COPY will need updating in gram.y and specifically the
'WITH' keyword will have 'IGNORE DUPLICATES' as well as 'NULL AS'.

Any pointers?

Thanks, Lee.


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: developer's faq
Next
From: Vince Vielhaber
Date:
Subject: Re: developer's faq