| From: | Jie Liang <jliang(at)ipinc(dot)com> |
|---|---|
| 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 18:31:36 |
| Message-ID: | Pine.BSF.4.10.10101251029410.73711-100000@tidal.ipinc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi,
Using a backslash to escape it.
insert into table(field) values('what\'s that');
Jie LIANG
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
jliang(at)ipinc(dot)com
www.ipinc.com
On Thu, 25 Jan 2001, Markus Wagner wrote:
> Hi,
>
> 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?
>
> Thanks,
>
> Markus
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergiy Ovcharuk | 2001-01-25 18:37:48 | Change or get currentdb |
| Previous Message | Dan Lyke | 2001-01-25 18:03:40 | Re: "'" in SQL INSERT statement |