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

From Remigiusz Sokolowski
Subject Re: [GENERAL] how to change delimiter single-quote ?
Date
Msg-id Pine.GS4.4.02A.9906300814220.22466-100000@netra.gdansk.sprint.pl
Whole thread Raw
In response to Re: [GENERAL] how to change delimiter single-quote ?  (Simon Drabble <simond@foxlink.net>)
List pgsql-general
>
> > 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');
>
I don't try it, but in such a cases I use something like that:
'Some \'quoted\' text'
    Rem

-------------------------------------------------------------------*------------
Remigiusz Sokolowski      e-mail: rems@gdansk.sprint.pl           * *
-----------------------------------------------------------------*****----------


pgsql-general by date:

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