| From: | John McKown <joarmc(at)swbell(dot)net> |
|---|---|
| To: | Thu Huynh <thu_huynh(at)hotmail(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Please HELP: insert row ... |
| Date: | 2000-10-14 13:21:05 |
| Message-ID: | Pine.LNX.4.21.0010140820130.28194-100000@linux2.johnmckown.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Simply double the qoute mark.
INSERT INTO table (name) VALUES('John''s house is in Dalas');
On Sat, 14 Oct 2000, Thu Huynh wrote:
> Hello,
>
> Does anyone know how to insert/update data that contains single quote (')
> into a field? Data such as: John's house is in Dalas.
>
> I know one can insert double quote by using single quotes as field
> delimiters. But since I have to use single quotes as field delimiters, data
> cannot contain single quote. Is there a way to change the field delimiter?
>
> Thanks for your helps.
>
> Thu.
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Charles Curley | 2000-10-14 13:23:32 | Re: Please HELP: insert row ... |
| Previous Message | Thu Huynh | 2000-10-14 04:15:11 | Please HELP: insert row ... |