Re: [GENERAL] how to change delimiter single-quote ?

From: "abdelkrim" <haj(at)idianet(dot)net>
To: "Simon Drabble" <simond(at)foxlink(dot)net>
Cc: <pgsql-general(at)hub(dot)org>
Subject: Re: [GENERAL] how to change delimiter single-quote ?
Date: 1999-06-29 18:45:40
Message-ID: 000e01bec25f$95f20360$0601a8c0@kosovo.idianet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)foxlink(dot)net
>

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

Browse pgsql-general by date

  From Date Subject
Next Message Colin Price (EML) 1999-06-29 19:53:22 [GENERAL] 6.4.2 and 6.5 date usertype difference
Previous Message Simon Drabble 1999-06-29 18:41:31 Re: [GENERAL] how to change delimiter single-quote ?