Re: Backslashitis

I think you need to double the quotes. Its mentioned in the PG documention
http://www.postgresql.org/docs/9.1/static/arrays.html

Eg:-

postgres=# update array_test set name=E'{"meet\\\\ing"}';
UPDATE 2
postgres=# select * from array_test ;
name
---------------
{"meet\\ing"}
{"meet\\ing"}
(2 rows)

---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/

On Thu, Jun 14, 2012 at 1:47 PM, <hamann(dot)w(at)t-online(dot)de> wrote:

> Hi,
>
> I have a column declared as array of text. I can get a single backslash
> into one of the array elements by
> update ... set mycol[1] = E'blah \\here'
> If I try to update the whole array
> update ... set mycol = E'{"blah \\here"}'
> the backslash is missing. I can get two backslashes there.
> Is there a good way to solve the problem, other than rewriting my update
> script to do array updates one element at a time?
>
> Regards
> Wolfgang Hamann
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>