Re: Special characters in SQL queries - Mailing list pgsql-sql

From Christoph Haller
Subject Re: Special characters in SQL queries
Date
Msg-id 3E6E0191.B8F06EBB@rodos.fzk.de
Whole thread Raw
In response to Special characters in SQL queries  (Vernon Wu <vernonw@gatewaytech.com>)
Responses Re: Special characters in SQL queries  (Vernon Wu <vernonw@gatewaytech.com>)
List pgsql-sql
>
> First a single quote in text, when a backforward slash in a file path,
what other special characters need padded in t
wo
> backslashes before using the data in a SQL statement?
>
> After hours' search in the PostgreSQL archive, I find a releted
information on the http://www.ca.postgresql.org/users
-
> lounge/docs/7.2/postgres/arrays.html.  It's about array data though.
>
> How can I find out those characters so that I can pre-process them
before a SQL query?
>
What about
size_t PQescapeString (char *to, const char *from, size_t length);
from the  libpq - C Library?

Regards, Christoph




pgsql-sql by date:

Previous
From: ObjectZ
Date:
Subject: Re: Execution plan Question
Next
From: Andreas Pflug
Date:
Subject: Re: How to notice column changes in trigger