Re: insert a value into a table

double the backslashes. They are an escape character.

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611 US

_____

From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of surabhi.ahuja
Sent: Friday, October 21, 2005 10:00 AM
To: pgsql-general(at)postgresql(dot)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