Received: from cncware.whidbey.com (IDENT:root@cncware.whidbey.com
	[208.25.171.37]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA54289
	for <pgsql-interfaces@postgreSQL.org>;
	Mon, 10 May 1999 12:36:15 -0400 (EDT) (envelope-from ken@ori-ind.com)
Received: from ken (ken.cncware.com [192.168.61.201])
	by cncware.whidbey.com (8.8.7/8.8.7) with SMTP id JAA05656
	for <pgsql-interfaces@postgreSQL.org>; Mon, 10 May 1999 09:35:28 -0700
Message-Id: <3.0.32.19990510093856.00803e20@ren.cncware.com>
X-Sender: ken_ori@ren.cncware.com
X-Mailer: Windows Eudora Pro Version 3.0 (32)
Date: Mon, 10 May 1999 09:38:58 -0700
To: pgsql-interfaces@postgreSQL.org
From: "Ken J. Wright" <ken@ori-ind.com>
Subject: Re: [INTERFACES] How to store '
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

At 02:56 PM 5/10/99 +0200, you wrote:
>"Ken J. Wright" ha scritto:
>
>> You have to preceed each occurence of ' with a \.
>> So "test'string" becomes "test\'string".
>>
>
>SQL92 says that you have to use the ' twice. If you want to write portable
>code, then:
>
>INSERT INTO table1 VALUES('WHAT''S THAT ?');
>and it becomes: WHAT'S THAT ?.

But just to clarify further, that only works with sql. Copy needs the '\'
approach.
So many choices ;-)

Ken