Re: Escape double-quotes in text[]?

On 29/04/2014 22:10, Raymond O'Donnell wrote:
> Hi all,
>
> Probably a silly question, but I'm having trouble figuring out the
> answer... if I'm constructing an string representation of a value to go
> into a text[] column, and one of the text literals includes
> double-quotes, do I need to escape the literal?
>
> For example, can I insert something like this into a text[] column
> directly? -
>
>   '{"abc", "de"f"}'
>
> Or would I need to do this? -
>
>   E'{"abc", "de"f"}'
>
> ....or something different again? I'm doing this from PHP via the Zend
> framework (v.1) if it makes any difference.

....and I should have mentioned that I'm on PostgreSQL 9.3.

R.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie