confused about backslashes - Mailing list pgsql-interfaces

From Frank Morton
Subject confused about backslashes
Date
Msg-id 00ae01bddb32$2ea0f4b0$8355e5ce@tesla.base2inc.com
Whole thread Raw
Responses Re: [INTERFACES] confused about backslashes  (Peter T Mount <peter@retep.org.uk>)
List pgsql-interfaces
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.




pgsql-interfaces by date:

Previous
From: Sferacarta Software
Date:
Subject: Re[2]: [INTERFACES] Re: DELETE FROM TABLE doesn't work (AGAIN)
Next
From: David Hartwig
Date:
Subject: Re: [INTERFACES] Re: DELETE FROM TABLE doesn't work (AGAIN)