Re: INSERT OR UPDATE - Mailing list pgsql-general

From Tony Wasson
Subject Re: INSERT OR UPDATE
Date
Msg-id 6d8daee30601022202g42666269ue144b28dab28ff4@mail.gmail.com
Whole thread Raw
In response to INSERT OR UPDATE  ("Julian Scarfe" <julian@avbrief.com>)
List pgsql-general
On 1/2/06, Julian Scarfe <julian@avbrief.com> wrote:
> I'm keeping config information for an application in a series of related
> tables.  I'd like a command that INSERTs data if it's new, or UPDATEs it if
> the key is duplicated.

A MERGE trigger will do exactly what you are asking for.

http://archives.postgresql.org/pgsql-sql/2004-05/msg00135.php

Send all your data as INSERTS.
The trigger will run a function to see if the row exists.
If the row exists -> rewrite it as it as an UPDATE
If the row does not exist -> leave the INSERT alone

Tony

pgsql-general by date:

Previous
From: Lucky Leavell
Date:
Subject: Re: Ident authentication failed
Next
From: Andrew - Supernews
Date:
Subject: Re: INSERT OR UPDATE