Colin DuPlantis <colind@sun.com> writes:
> I am having trouble inserting a value into the array column that
> contains a single '\' (no quotes) character. The following examples are
> my attempts to produce a value of 'x\y' (no quotes) in both the regular
> text and the text array columns in the test table:
> insert into test values ( 'x\\y', array['x\\y']);
> c1 | c2
> -----+----------
> x\y | {"x\\y"}
> (1 row)
The above is perfectly correct: the actual value in c2[1] is 'x\y'.
Read the docs about array I/O formatting:
http://www.postgresql.org/docs/8.1/static/arrays.html#AEN5716
regards, tom lane