Re: Bug #524: Bad quoting of backslash in text arrays - Mailing list pgsql-bugs

pgsql-bugs@postgresql.org writes:
> Note that the backslash between aaa and bbb should be doubled.

Yeah, I think you're right.  I get:

regression=# select a from test;
        a
------------------
 {"aaa\bbb\"ccc"}
(1 row)

regression=# select a[1] from test;
      a
-------------
 aaa\bbb"ccc
(1 row)

If the array output routine is going to backslash the ", methinks it'd
better backslash the backslash too.

Any objections to changing this behavior?

            regards, tom lane