Backslash problems with 8.1.4

Поиск
Список
Период
Сортировка
От Matthew Schumacher
Тема Backslash problems with 8.1.4
Дата
Msg-id 4487021A.2080706@aptalaska.net
обсуждение исходный текст
Ответы Re: Backslash problems with 8.1.4  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hello list,

I upgraded to postgres-8.1.4 and saw all of the backslash escape changes
and understand why, but I can't figure out how to put a literal \' in
the database. If \ is no longer escaping shouldn't I be able to use \”
and have postgres ignore the \ and use standard sql syntax to escape the
single '?

It seems that no matter what I try postgres returns an error message
because it thinks I'm trying to escape the '.

The data is coming from PHP, and yes, I know that embedded SQL is bad,
but I want to disable \ escaping now since I don't use it and it will be
a little while before I can convert to PDO.

Is there any way to disable \ escaping and pass a literal \' without
postgres kicking back an error on the query?

schu

В списке pgsql-general по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: pgcrypto sha256/384/512 don't work on Redhat. Please help!
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Import Data from MS SQL Server