Skip site navigation (1) Skip section navigation (2)

mysql replace in postgreSQL?

From: blackwater dev <blackwaterdev(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: mysql replace in postgreSQL?
Date: 2005-10-29 01:57:03
Message-ID: 34a9824e0510281857n3b4a3d01gc82f615a5f3a5d9b@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
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.

Responses

pgsql-general by date

Next:From: Uzo MadujibeyaDate: 2005-10-29 01:57:45
Subject: Backup problem...No BIN directory!!!
Previous:From: Robert TreatDate: 2005-10-29 01:47:17
Subject: postgis / mediawiki / postgresql was Re: [Freegis-list] Re: [GENERAL] Map of Postgresql Users (OT)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group