Quick Links

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
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
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

Re: mysql replace in postgreSQL? at 2005-10-29 02:12:14 from Joshua D. Drake
Re: mysql replace in postgreSQL? at 2005-10-29 03:12:24 from Bricklen Anderson
Re: mysql replace in postgreSQL? at 2005-10-29 08:21:08 from Kostas Maistrelis
Re: mysql replace in postgreSQL? at 2005-10-30 07:14:33 from cristian
Re: mysql replace in postgreSQL? at 2005-10-30 14:29:41 from David Fetter

Browse pgsql-general by date

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