Re: Arrays and backslashes

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