Content-Type: text/plain;
  charset="utf-8"
From: Richard Huxton <dev@archonet.com>
Organization: Archonet Ltd
To: "Vaughn Cleminson" <vaughn@the-i-junction.com.removethis>,
	pgsql-sql@postgresql.org
Subject: Re: Does Postgres replace \\ with \ in an update query
Date: Fri, 15 Nov 2002 18:48:35 +0000
User-Agent: KMail/1.4.3
References: <3dd4a0e4.0@news1.mweb.co.za>
In-Reply-To: <3dd4a0e4.0@news1.mweb.co.za>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200211151848.35639.dev@archonet.com>

On Friday 15 Nov 2002 7:23 am, Vaughn Cleminson wrote:
> Hi All
>
> I am doing a normal SQL update against postgres.
> Seems to be replacing \\ with \ when it gets saved in the database. eg.
> \\machine\folder is being replaced with \machine
>
> Any ideas?

The backslash (\) character is used to escape other characters from normal=
=20
interpretation, so you can have a text value: 'Richard\'s text' which means=
=20
during processing the backslash is removed.

If you want to actually have a backslash in your sql you'll need to escape =
it=20
too. So you'll have something like:

INSERT INTO foo (path) VALUES ('\\\\machine\\folder');

Most application languages offer something like a quote_sql() function whic=
h=20
handles all the details of this for you.

--=20
  Richard Huxton