Backslash problems with 8.1.4

From: Matthew Schumacher <matt(dot)s(at)aptalaska(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Backslash problems with 8.1.4
Date: 2006-06-07 16:43:06
Message-ID: 4487021A.2080706@aptalaska.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2006-06-07 17:03:11 Re: pgcrypto sha256/384/512 don't work on Redhat. Please help!
Previous Message Tom Lane 2006-06-07 15:52:01 Re: Some mystery with execution plans on postgres 8.1