copy or update question

From: Thomas Keller <kellert(at)ohsu(dot)edu>
To: Postgresql PDX_Users <pdxpug(at)postgresql(dot)org>
Subject: copy or update question
Date: 2008-04-03 21:37:34
Message-ID: 738B654F-366F-4789-BB84-B8B52A743DA4@ohsu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pdxpug

Greetings,
I have a large (6K records) csv file for which I would like to use
COPY if the record is new, or UPDATE if the primary key already
exists in the table. Can I do that with psql?

thanks,

Tom Keller
MMI Shared Resource Facility
503-494-2442
kellert at ohsu.edu

Responses

Browse pdxpug by date

  From Date Subject
Next Message Selena Deckelmann 2008-04-03 22:00:45 Re: copy or update question
Previous Message Randal L. Schwartz 2008-04-03 04:40:01 Re: Fwd: UG News: OSCON "Locals Only" Discount