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

mysql's "replace into..."

From: "Diehl, Jeffrey" <jdiehl(at)sandia(dot)gov>
To: "'pgsql-sql(at)postgreSQL(dot)org'" <pgsql-sql(at)postgreSQL(dot)org>
Subject: mysql's "replace into..."
Date: 2001-02-28 18:40:51
Message-ID: B51F0C636E578A4E832D3958690CD73E0130BE49@es04snlnt (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
Hi all,

I'm in the process of migrating a production database and related
applicatoins from mysql to postgresql.  I've just not been very impressed
with mysql's stability, that is I'm trying to make my phone stop ringing.

However, when I wrote the applications, I took free advantage of mysql's
replace into feature which behaves like a smart insert that inserts new
records or updates old records.  I'm using perl DBI and need to figure out a
good way to migrate this to postgresql. 

Any ideas?

Mike Diehl.


pgsql-sql by date

Next:From: Josh BerkusDate: 2001-02-28 19:13:03
Subject: Updatable Views
Previous:From: Bruce MomjianDate: 2001-02-28 17:05:02
Subject: Re: Debug messages in beta5

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