Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2RK4Pw87851 for ; Tue, 27 Mar 2001 15:04:25 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f2RK4Bw15039; Tue, 27 Mar 2001 15:04:11 -0500 (EST) To: "Diehl, Jeffrey" cc: pgsql-sql@postgresql.org Subject: Re: Replace into...? In-reply-to: References: Comments: In-reply-to "Diehl, Jeffrey" message dated "Tue, 27 Mar 2001 12:30:46 -0700" Date: Tue, 27 Mar 2001 15:04:11 -0500 Message-ID: <15036.985723451@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200103/557 X-Sequence-Number: 2227 "Diehl, Jeffrey" writes: > I'm in the process of migrating a database and application suite from mysql > to postgresql. The problem is that I've used > mysql's "replace into..." quite frequently... > Does anyone know of a "clean" way to implement this feature in postgresql? > I really don't want my applications to have to know what indexes are in > place for a given table. I'm confused. What does "replace into" have to do with having to know what indexes are in place? regards, tom lane