Backslash problems with 8.1.4 - Mailing list pgsql-general

From Matthew Schumacher
Subject Backslash problems with 8.1.4
Date
Msg-id 4487021A.2080706@aptalaska.net
Whole thread Raw
Responses Re: Backslash problems with 8.1.4
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pgcrypto sha256/384/512 don't work on Redhat. Please help!
Next
From: "Merlin Moncure"
Date:
Subject: Re: Import Data from MS SQL Server