Special characters in SQL queries - Mailing list pgsql-sql

From Vernon Wu
Subject Special characters in SQL queries
Date
Msg-id TN5Y5ZRN04U06TR63FAUPTNZYX8471.3e6b9bc8@kimiko
Whole thread Raw
List pgsql-sql
First a single quote in text, when a backforward slash in a file path, what other special characters need padded in two

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?

Thanks for your information.

Vernon 







pgsql-sql by date:

Previous
From: Rod Taylor
Date:
Subject: Re: check if table/object is locked
Next
From: Tom Lane
Date:
Subject: Cursors and backwards scans and SCROLL