Re: Backslash as ordinary char vs. not; set via a connection/session - Mailing list pgsql-general

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:  nonstandard use of \\ in a string literal
> LINE 1: insert into backslash values ('\\');
>                                       ^
> HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
> INSERT 0 1
> foo=# select * from backslash;
>  baz
> -----
>  \\
>  \
> (2 rows)
>
>
> like that ? :-)
>
>


Yes - that is the eye candy I'm looking for. Anxiously looking forward
to 8.2 :-)

ken