Re: mysql replace in postgreSQL? - Mailing list pgsql-general

From Bricklen Anderson
Subject Re: mysql replace in postgreSQL?
Date
Msg-id 4362E898.6050303@shaw.ca
Whole thread Raw
In response to mysql replace in postgreSQL?  (blackwater dev <blackwaterdev@gmail.com>)
List pgsql-general
blackwater dev wrote:
> In MySQL, I can use the replace statement which either updates the
> data there or inserts it.  Is there a comporable syntax to use in
> postgreSQL?
>
> I need to do an insert and don't want to have to worry about if the
> data is already there or not...so don't want to see if it there, if so
> do update if not insert...etc.
>
> Thanks.
>

In Oracle this is called the MERGE statement, but it not yet in pg. It
is on the TODO list, though.

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Installation trouble -- oops
Next
From: "w_tom"
Date:
Subject: Re: Why database is corrupted after re-booting