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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-02-28 19:13:03 Updatable Views
Previous Message Bruce Momjian 2001-02-28 17:05:02 Re: Debug messages in beta5