Postgres Pro
Downloads
Home   >   mailing lists

Can COPY update or skip existing records? - Mailing list pgsql-sql

From Glenn Gillen
Subject Can COPY update or skip existing records?
Date
Msg-id 69b2ac8a0809300516t3495c25y2d6a5e00f2c3377c@mail.gmail.com
Whole thread Raw
Responses Re: Can COPY update or skip existing records?  ("Rafael Domiciano" <rafael.domiciano@gmail.com>)
Re: Can COPY update or skip existing records?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: Can COPY update or skip existing records?  ("Tony Wasson" <ajwasson@gmail.com>)
List pgsql-sql
Tree view 
Hey all,

I've got a table with a unique constraint across a few fields which I
need to regularly import a batch of data into. Is there a way to do it
with COPY without getting conflicts on the unique contraint? I have no
was of being certain that some of the data I'm trying to load isn't in
the table already.

Ideally I'd like it to operate like MySQL's on_duplicate_key_update
option, but for now I'll suffice with just ignoring existing rows and
proceeding with everything else.

Thanks,

-- 
Glenn

pgsql-sql by date:

Previous
From: az@svilendobrev.com
Date:
Subject: optimizing a query over tree-like structure
Next
From: "Oliveiros Cristina"
Date:
Subject: Re: optimizing a query over tree-like structure