From: | "Joe Shevland" <shevlandj(at)kpi(dot)com(dot)au> |
---|---|
To: | "The Hermit Hacker" <scrappy(at)hub(dot)org>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-interfaces(at)postgreSQL(dot)org> |
Subject: | Re: [INTERFACES] escaping characters ... |
Date: | 2000-01-05 17:33:56 |
Message-ID: | 008201bf57a3$14d5b9a0$6464a8c0@kpi.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
What about: % and ? for like clauses... I think the function in question
would be a handy option though. I almost always implement one of these
methods in the application code.
Regards,
Joe Shevland
----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "The Hermit Hacker" <scrappy(at)hub(dot)org>
Cc: <pgsql-interfaces(at)postgreSQL(dot)org>
Sent: Tuesday, January 04, 2000 10:12 AM
Subject: Re: [INTERFACES] escaping characters ...
> The Hermit Hacker <scrappy(at)hub(dot)org> writes:
> > MySQl has 'mysql_escape_string' in it's client library. Does Pg have
> > something like that?
>
> libpq doesn't provide any such function --- perhaps it should, but
> on the other hand the amount of code involved is pretty tiny, and
> issues like memory allocation/freeing would complicate the definition
> of the function.
>
> > if not, what should be escaped?
>
> When generating quoted strings for use in SQL commands, you should
> prefix single-quote (') and backslash (\) characters with a backslash.
> I think that's all.
>
> COPY IN/OUT data has a different set of rules. There, you can but
> don't have to backslash single quotes. You do need to convert returns
> and tabs into \n and \t, and of course backslash itself must be doubled.
> (If you are using some other character than tab as the field delimiter,
> then it'd need backslashing instead.)
>
> Data returned by libpq after a SELECT is not quoted at all.
>
> regards, tom lane
>
> ************
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 2000-01-05 18:10:14 | Re: ECPG documentation |
Previous Message | nathan | 2000-01-05 17:26:12 | ECPG and remote databases |