postgresql-8.2-504.jdbc4.jar and backslash

From: "roman" <xroot(at)mail(dot)ru>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: postgresql-8.2-504.jdbc4.jar and backslash
Date: 2007-05-07 06:15:25
Message-ID: 00c401c7906f$1ada1d20$5405a8c0@nnp.nsk.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello.
I use this jar driver for connection to postgresql 8.2.3-1 in Windows XP.
In my database I use UFT8 codepage.
I need to save some filepath in some character varying(255) field in table1.
That path looks like this: f:\temp
in String class like this: "f:\\temp";
I try to execute following SQL statement:
UPDATE "table1" SET "field1"='f:\\temp'
in String object it looks like: "UPDATE \"table1\" SET \"field1\"='f:\\temp'".
After statement executed I get on SELECT folowing:
f:<tab symbol>emp

Why? There were two back slashes!!!
When I try to execute that update statement in pgAdminIII everything is OK!!!

Please, help me to decide this problem. How can I save filepath with backslashes?

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Norbert Radyk 2007-05-07 07:10:45 Closing all existing PostgreSQL database connections
Previous Message Badawy, Mohamed 2007-05-06 07:14:16 Re: connection variables problem