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: (view raw or whole thread)
Lists: pgsql-hackers

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:


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


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-2017 The PostgreSQL Global Development Group