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.