pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: rverghese <riyav@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: ignore unique violation OR check row exists
Date: Wed, 4 Jan 2012 09:34:35 -0800 (PST)
Message-ID: <1325698475096-5120317.post@n5.nabble.com> (raw)
In-Reply-To: <4F044733.6020007@siix.com>
References: <1325624070446-5117916.post@n5.nabble.com>
	<20120104090838.GA6039@tux>
	<4F042291.6040903@siix.com>
	<CAEV0TzCGTt4R-Ca+v1bwXXhLQEfU5v-m7bGebkRucSj8S9t8YQ@mail.gmail.com>
	<4F044733.6020007@siix.com>

Thanks for the recommendations. Unfortunately I have to clean out the data
before I insert, so I cannot do a bulk copy from a CSV, I will try the
option of inserting into src table and then copying relevant data to dest
table and see if that works faster for me. I suppose I could bulk insert and
then clean out the data before I insert into destination table. I'll have to
see how long that takes.


--
View this message in context: http://postgresql.1045698.n5.nabble.com/ignore-unique-violation-OR-check-row-exists-tp5117916p512031...
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.



view thread (9+ messages)

Message-ID: <1325698475096-5120317.post@n5.nabble.com>
Permalink:  ../1325698475096-5120317.post@n5.nabble.com/
Also on:    postgresql.org/message-id/1325698475096-5120317.post@n5.nabble.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: riyav@hotmail.com
  Subject: Re: ignore unique violation OR check row exists
  In-Reply-To: <1325698475096-5120317.post@n5.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox