Skip site navigation (1) Skip section navigation (2)

Re: BUG #3872: backslash_quote = off doesn't work any more

From: Tomasz Ostrowski <tometzky(at)batory(dot)org(dot)pl>
To: David Gradwell <david(at)gradwell(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3872: backslash_quote = off doesn't work any more
Date: 2008-01-16 13:43:29
Message-ID: 20080116134329.GB18961@batory.org.pl (view raw or flat)
Thread:
Lists: pgsql-bugs
On Mon, 14 Jan 2008, David Gradwell wrote:

> Description:        backslash_quote = off doesn't work any more

I think you need to
	set standard_conforming_strings=on;
instead.

Then:
	select '\''012'::text;
	 text  
	-------
	 \'012
	(1 row)

	 select '\012'::text;
	 text 
	------
	 \012
	(1 row)

I think this backslash_quote is ignored when
standard_conforming_strings is on.

Regards
Tometzky
-- 
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
                                                      Winnie the Pooh

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2008-01-16 15:32:14
Subject: Re: BUG #3872: backslash_quote = off doesn't work any more
Previous:From: David WheelerDate: 2008-01-16 00:28:04
Subject: BUG #3879: OS X Start Script should not `cd /Users/postgres`

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group