Re: Inserting string with a " into an array using {} syntax ... possible?

Bill Moran wrote:

> bill=# insert into testarray (a) values (E'{"text \\"for you\\"","moretext"}');
> INSERT 0 1
> bill=# select * from testarray;
> a | id
> -------------------------------+----
> {"text \"for you\"",moretext} | 3

Actually this one is good. It gets the backslashes in the output because the "
need to be escaped there too ('cause it's an array). But if you output a
single element, they are not there:

alvherre=# insert into f values (E'{"text \\"for you\\" some"}');
INSERT 0 1
alvherre=# select * from f;
a
---------------------------
{"text \"for you\" some"}
(1 fila)

alvherre=# select a[1] from f;
a
---------------------
text "for you" some
(1 fila)

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.