| From: | Kenneth Marshall <ktm(at)rice(dot)edu> |
|---|---|
| To: | John Fabiani <johnf(at)jfcomputer(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: quotes etc |
| Date: | 2011-02-22 20:48:12 |
| Message-ID: | 20110222204812.GA9375@aart.is.rice.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Tue, Feb 22, 2011 at 12:26:41PM -0800, John Fabiani wrote:
> Hi,
> I would have thought that there would be a simple built-in function that would
> escape the quotes as ('D' Andes') to ('D\' Andes'). But I did not see
> anything?
>
> I am I wrong?
>
> Johnf
>
The manual goes over many permutations of the escape process and
what options can be used in each case. I would start there, because
for example, escaping a "'" in SQL uses two "'"s: i.e. 'D' Andes'
becomes 'D'' Andes' I think. Procedural languages and libpq can
offer many other options for escape processing.
Cheers,
Ken
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2011-02-22 21:18:56 | Re: quotes etc |
| Previous Message | John Fabiani | 2011-02-22 20:26:41 | quotes etc |