On 1/2/06, Julian Scarfe <julian(at)avbrief(dot)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