Skip site navigation (1) Skip section navigation (2)

Re: Bulkloading using COPY - ignore duplicates?

From: Lee Kindness <lkindness(at)csl(dot)co(dot)uk>
To: pgsql-hackers(at)postgresql(dot)org
Cc: lkindness(at)csl(dot)co(dot)uk
Subject: Re: Bulkloading using COPY - ignore duplicates?
Date: 2001-10-01 15:31:06
Message-ID: 15288.35898.813740.887368@elsick.csl.co.uk (view raw or flat)
Thread:
Lists: 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.

In response to

Responses

pgsql-hackers by date

Next:From: Vince VielhaberDate: 2001-10-01 15:36:56
Subject: Re: developer's faq
Previous:From: Bruce MomjianDate: 2001-10-01 15:29:13
Subject: Re: developer's faq

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group