Received: from athena.evoserve.com (athena.evoserve.com [210.16.10.134]) by hub.org (8.9.2/8.9.1) with ESMTP id LAA08210 for ; Sat, 20 Mar 1999 11:07:19 -0500 (EST) (envelope-from brianb@evoserve.com) Received: from evoserve.com (txn-dial1-27.evoserve.com [210.16.11.27] (may be forged)) by athena.evoserve.com (8.8.8/8.7.3) with ESMTP id AAA02248; Sun, 21 Mar 1999 00:07:21 +0800 (GMT+0800) Message-ID: <36F3C76D.42F9EAFD@evoserve.com> Date: Sun, 21 Mar 1999 00:06:05 +0800 From: Brian Baquiran Organization: Evoserve X-Mailer: Mozilla 4.06 [en] (Win95; I) MIME-Version: 1.0 To: pgsql-sql@postgreSQL.org Subject: Re: [SQL] string containing (') References: <199903201248.HAA19314@candle.pha.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Bruce Momjian wrote: > > > HI! > > Can anyone help, > > I want to store a string into a relation that might contain an apostrophe > > ('). Is there anyway around this or can I not store such strings. > > Thanks for your help > > '\'' I've always thought the proper way was to use 2 quotes (''). Brian