double the backslashes. They are an escape
character.
--
Larry
Rosenman
http://www.lerctr.org/~ler
Phone: +1
972-414-9812
E-Mail: ler@lerctr.org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611
US
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of surabhi.ahuja
Sent: Friday, October 21, 2005 10:00 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] insert a value into a table
i have a fiels -
varchar(100)
to this fiels i am trying to insert
"abc\def\xyz'
but it is not inserting the whole thing
...
how can i ensure that the whole string including
the backslashes get inserted into the table
thanks
regards
surabhi