Postgres Pro
Downloads
Home   >   mailing lists

INSERT OU UPDATE WITHOUT SELECT? - Mailing list pgsql-performance

From Waldomiro
Subject INSERT OU UPDATE WITHOUT SELECT?
Date
Msg-id 447C8F1D.8090404@shx.com.br
Whole thread Raw
Responses Re: INSERT OU UPDATE WITHOUT SELECT?  ("Jonah H. Harris" <jonah.harris@gmail.com>)
List pgsql-performance
Tree view
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.

pgsql-performance by date:

Previous
From: Anthony Ransley
Date:
Subject: Split select completes, single select doesn't and becomes IO bound!
Next
From: "Jonah H. Harris"
Date:
Subject: Re: INSERT OU UPDATE WITHOUT SELECT?