Re: [GENERAL] how to change delimiter single-quote ? - Mailing list pgsql-general

From Simon Drabble
Subject Re: [GENERAL] how to change delimiter single-quote ?
Date
Msg-id Pine.LNX.3.96.990629143906.12766A-100000@dragon
Whole thread Raw
In response to how to change delimiter single-quote ?  ("abdelkrim" <haj@idianet.net>)
Responses Re: [GENERAL] how to change delimiter single-quote ?  (Remigiusz Sokolowski <rems@gdansk.sprint.pl>)
List pgsql-general
On Tue, 29 Jun 1999, abdelkrim wrote:

> Hello
>
> I'have some problems with single-quote,
> if i insert some text with single-quote ( ' ) error occured !!!
> thanks
>
>
>

The common way to achieve this is to double up the quotes:

INSERT INTO table (column) VALUES ('Some ''quoted'' text');


Simon.


--
 "Half-dead cat found in box -- Animal Rights group seeks Austrian scientist"

   Simon Drabble                      Somewhere in cyberspace
   simond@foxlink.net


pgsql-general by date:

Previous
From: inlin
Date:
Subject: About the restore from V1.09 to V6.3.2
Next
From: "abdelkrim"
Date:
Subject: Re: [GENERAL] how to change delimiter single-quote ?