Hi Ketan,
On Jul 15, 2005, at 10:49 PM, ketan shah wrote:
> 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...
As you've noticed, the \ character is currently used in PostgreSQL as
an escape, so '\\' is recognized as one \. So if you want to insert \
\, you need to escape both \; i.e., '\\\\'
test=# select '\\';
?column?
----------
\
(1 row)
test=# select '\\\\';
?column?
----------
\\
(1 row)
test=# create table tab1 (
usr_id varchar(15)
, usr_name varchar(20)
,usr_filename_pattern varchar(1024)
);
CREATE TABLE
test=# insert into tab1 (usr_id, usr_name, usr_filename_pattern)
values ('A','Mr. A','A\\d\\d\\d\\d');
INSERT 82771 1
test=# insert into tab1 (usr_id, usr_name, usr_filename_pattern)
values ('A','Mr. B','A\\\\d\\\\d\\\\d\\\\d');
INSERT 82772 1
test=# select * from tab1;
usr_id | usr_name | usr_filename_pattern
--------+----------+----------------------
A | Mr. A | A\d\d\d\d
A | Mr. B | A\\d\\d\\d\\d
(2 rows)
Is this what you're looking for?
As an aside, I find it very helpful to name the columns when I'm
inserting them. (INSERT INTO foo (bar, baz, bat) VALUES ... instead
of INSERT INTO foo VALUES ... )Then I don't have to remember exactly
which column order I used when creating the table.
Hope this helps.
Michael Glaesemann
grzm myrealbox com