Re: Backslashitis

>
> With standard conforming strings on, you could use any of the following:
>
> update foo set a= E'{"blah \\\\here"}';
> update foo set a= '{"blah \\here"}';
> update foo set a= ARRAY[E'blah \\here'];
> update foo set a= ARRAY['blah \here'];
>
> I tend to prefer the ARRAY[...] constructor syntax because it doesn't
> require any additional escaping of individual elements.
>
>
> http://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-STRINGS-ESCAPE
>
>
> http://www.postgresql.org/docs/current/static/sql-expressions.html#SQL-SYNTAX-ARRAY-CONSTRUCTORS
>
> Regards,
> Dean
>

Thanks

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