Re: Backslash as ordinary char vs. not; set via a connection/session

From: Ken Johanson <pg-user(at)kensystem(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Backslash as ordinary char vs. not; set via a connection/session
Date: 2006-07-27 21:14:50
Message-ID: 44C92CCA.7000107@kensystem.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shoaib Mir 2006-07-27 21:17:51 Re: Permissions to connect to postgres database
Previous Message Tom Lane 2006-07-27 21:06:47 Re: Using an alternate PGDATA on RHEL4 with SELinux enabled