| From: | "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net> |
|---|---|
| To: | Markus Wagner <wagner(at)imsd(dot)uni-mainz(dot)de> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: "'" in SQL INSERT statement |
| Date: | 2001-01-25 10:49:01 |
| Message-ID: | Pine.LNX.4.30.0101250547420.10432-100000@chapelperilous.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Thu, 25 Jan 2001, Markus Wagner wrote:
> I have some data that I wish to transfer into a database using perl/DBI.
> Some of the data are strings containing the apostrophe "'" which I use
> as string delimiter.
>
> How can I put these into my database using the INSERT statement?
You will need to escape them with the \ character. So "Bill's Garage"
will become "Bill\'s Garage".
-- Brett
http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
Romeo wasn't bilked in a day.
-- Walt Kelly, "Ten Ever-Lovin' Blue-Eyed Years With Pogo"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brett W. McCoy | 2001-01-25 12:11:06 | Re: Re: Problem with Dates |
| Previous Message | Alessio Bragadini | 2001-01-25 10:30:56 | Re: "'" in SQL INSERT statement |