INSERT OR UPDATE WITHOUT SELECT

From: wmiro(at)ig(dot)com(dot)br <wmiro(at)ig(dot)com(dot)br>
To: pgsql-performance(at)postgresql(dot)org
Subject: INSERT OR UPDATE WITHOUT SELECT
Date: 2006-05-30 20:47:47
Message-ID: 20060530_204747_020181.wmiro@ig.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

Is there a command to Insert a record If It does not exists and a update if
It exists?

I do not want to do a select before a insert or update.

I mean the postgres should test if a record exist before insert and if It
exist then the postgres must do an update instead an insert.

Thanks,

WMiro.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Francisco Reyes 2006-05-30 20:52:32 Re: Adding and filling new column on big table
Previous Message PFC 2006-05-30 20:24:32 Re: Adding and filling new column on big table