Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Bulkloading using COPY - ignore duplicates?
Date
Msg-id 13570.1008691152@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bulkloading using COPY - ignore duplicates?  (Lee Kindness <lkindness@csl.co.uk>)
Responses Re: Bulkloading using COPY - ignore duplicates?  (Lee Kindness <lkindness@csl.co.uk>)
List pgsql-hackers
Tree view 
Lee Kindness <lkindness@csl.co.uk> writes:
> In an ideal world 'COPY FROM' would only be used with data output by
> 'COPY TO' and it would be nice and sanitised. However in some fields
> this often is not a possibility due to performance constraints!

Of course, the more bells and whistles we add to COPY, the slower it
will get, which rather defeats the purpose no?
        regards, tom lane

pgsql-hackers by date:

Previous
From: Lee Kindness
Date:
Subject: Re: Bulkloading using COPY - ignore duplicates?
Next
From: Giuseppe Tanzilli - CSF
Date:
Subject: RFC: Locale support for Numeric datatype