Re: how to insert '\\' in postgres database using java

If, as the name of the column suggests, the backslash is used for
pathnames, why don't you bypass the problem by using normal slash (I.E:
"path/to/my/file")? It works well
with new windows versions and, of course, unix-style pathnames....

Hope this helps, Roberto

ketan shah wrote:

> Hi,
>   All,
> My name is ketan, i have problem in postgres db insert..
>  Here is my problem.
> i have created table like..
> 1)  Create table tab1(usr_id varchar(15), usr_name
> varchar(20),usr_filename_pattern varchar(1024));
>       insert table tab1 values('A','Mr. A','A\\d\\d\\d\\d');
>      Record is successfully inserted But when i retrieve using java
> program..
>       select * from tab1;
>      The output is 'A',     'Mr. A',      'A\d\d\d\d'
> (means it escapeing '\')
>      Also when i update the record
>      update tab1 set usr_name='Mr. B' where usr_id='A';
>
>      and after succefully  updation when i try to retrieve record by
>     select * from tab1;
>    output is  'A','Mr. B', 'Adddd'    ; (means it escapeing '\'     again)
>
>    My question :
>     After updation  how i get
>    'A', 'Mr. B', 'A\\d\\d\\d\\d'
>   i.e. not escapeing '\\'.
>   I am using postgres 7.4.6 and java 1.4.
> pl. help me out...
>
> Thanks in advanced..
> ketan
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>