| From: | Charles Curley <ccurley(at)trib(dot)com> |
|---|---|
| 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:23:32 |
| Message-ID: | 20001014072332.D10114@trib.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Sat, Oct 14, 2000 at 04:15:11AM +0000, 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?
Try escaping the single quote you want to put into the database.
'John\'s house is in Dalas'
--
-- C^2
No windows were crashed in the making of this email.
Looking for fine software and/or web pages?
http://w3.trib.com/~ccurley
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albert REINER | 2000-10-14 14:47:04 | Re: Please HELP: insert row ... |
| Previous Message | John McKown | 2000-10-14 13:21:05 | Re: Please HELP: insert row ... |