Stefan Kaltenbrunner wrote:
foo=# create table backslash(baz text);
CREATE TABLE
foo=# set standard_conforming_strings to on;
SET
foo=# insert into backslash values ('\\');
INSERT 0 1
foo=# set standard_conforming_strings to off;
SET
foo=# insert into backslash values ('\\');
WARNING: nonstandar
Ken Johanson wrote:
> Stefan Kaltenbrunner wrote:
>
>>
>> postgresql can do that in an even more powerful way - but people tend to
>> not notice much of it in your case that would be:
>>
>> ALTER ROLE foo SET standard_conforming_strings='off'
>>
>> or even:
>>
>> ALTER DATABASE bar SET standard_co
Stefan Kaltenbrunner wrote:
postgresql can do that in an even more powerful way - but people tend to
not notice much of it in your case that would be:
ALTER ROLE foo SET standard_conforming_strings='off'
or even:
ALTER DATABASE bar SET standard_conforming_strings='off'
you can do that for n
Ken Johanson wrote:
> Tom and folks,
>
> Will it be possible to set this more standard backslash handling
> behavior -- and possibly similar conformance modes... in a way similar
> to how mysql allows? They allow one to issue commands on the connection
> like:
>
> SET SESSION sql_mode = 'NO_BACKS
Ken Johanson wrote:
> Tom and folks,
>
> Will it be possible to set this more standard backslash handling
> behavior -- and possibly similar conformance modes... in a way similar
> to how mysql allows? They allow one to issue commands on the connection
> like:
>
> SET SESSION sql_mode = 'NO_BACKS
Tom and folks,
Will it be possible to set this more standard backslash handling
behavior -- and possibly similar conformance modes... in a way similar
to how mysql allows? They allow one to issue commands on the connection
like:
SET SESSION sql_mode = 'NO_BACKSLASH_ESCAPES,IGNORE_SPACE,ANSI'
Th
