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
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 |