From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | 'PostgreSQL' <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Escape double-quotes in text[]? |
Date: | 2014-04-29 21:13:23 |
Message-ID: | 536015F3.2030408@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)iol(dot)ie
From | Date | Subject | |
---|---|---|---|
Next Message | David G Johnston | 2014-04-29 21:54:10 | Re: Escape double-quotes in text[]? |
Previous Message | Raymond O'Donnell | 2014-04-29 21:10:55 | Escape double-quotes in text[]? |