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

From abdelkrim
Subject Re: [GENERAL] how to change delimiter single-quote ?
Date
Msg-id 000e01bec25f$95f20360$0601a8c0@kosovo.idianet.net
Whole thread Raw
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
>


is't no way to change the single-quote to an another character ?



pgsql-general by date:

Previous
From: Simon Drabble
Date:
Subject: Re: [GENERAL] how to change delimiter single-quote ?
Next
From: "Colin Price (EML)"
Date:
Subject: [GENERAL] 6.4.2 and 6.5 date usertype difference