From: | Remigiusz Sokolowski <rems(at)gdansk(dot)sprint(dot)pl> |
---|---|
To: | Simon Drabble <simond(at)foxlink(dot)net> |
Cc: | abdelkrim <haj(at)idianet(dot)net>, pgsql-general(at)hub(dot)org |
Subject: | Re: [GENERAL] how to change delimiter single-quote ? |
Date: | 1999-06-30 06:15:25 |
Message-ID: | Pine.GS4.4.02A.9906300814220.22466-100000@netra.gdansk.sprint.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)gdansk(dot)sprint(dot)pl * *
-----------------------------------------------------------------*****----------
From | Date | Subject | |
---|---|---|---|
Next Message | inlin | 1999-06-30 06:21:26 | About the restore from V1.09 to V6.3.2 |
Previous Message | Chris Bitmead | 1999-06-29 23:58:45 | Re: [GENERAL] how to change delimiter single-quote ? |