| 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: | Whole Thread | Raw Message | 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 ? |