Message-ID: <00ae01bddb32$2ea0f4b0$8355e5ce@tesla.base2inc.com>
Reply-To: "Frank Morton" <fmorton@mail.base2inc.com>
From: "Frank Morton" <fmorton@mail.base2inc.com>
To: "pgsql-interfaces@postgresql.org" <pgsql-interfaces@postgreSQL.org>
Subject: confused about backslashes
Date: Tue, 8 Sep 1998 09:08:41 -0500

can someone help me out here.

I want to put the real text data of "\\QM_RIP1\HEIDEL41"
in a text field.

If I put double backslashes representing one backslash
in an insert statement as in "\\\\QM_RIP1\\HEIDEL41"
and then do a select on that field with psql, I actually see
the double backslashes (unexpected). But, if i do a query
using JDBC, it does correctly revert to the single backslash
I originally was after. I still don't follow this, but it works, so
I could just ignore it.

However, then i I do a dump of the database with "pg_dump -d",
this same field comes back out with single backslashes, which
if you pipe as input to psql to reload, the field is missing the
backslashes again.

Could someone explain this to me.