| From: | David Gauthier <dfgpostgres(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | escaping double-quotes in varchar array |
| Date: | 2022-11-09 01:27:35 |
| Message-ID: | CAEs=6DnhWbh5QfbZAZy6BdoGdLJ28MCoU1T6pAiZhw6Ze4gMUw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
psql (11.5, server 11.3) on linux
Trying to insert a string containing a double-quote into a varchar arr.
Here's my attempt
dvdb=# create table testarr (arr varchar[]);
CREATE TABLE
dvdb=# insert into testarr (arr) values ('{"abcdefg"}');
INSERT 0 1
dvdb=# select * from testarr;
arr
-----------
{abcdefg}
(1 row)
dvdb=# insert into testarr (arr) values ('{"hijk"lmnop"}');
ERROR: malformed array literal: "{"hijk"lmnop"}"
LINE 1: insert into testarr (arr) values ('{"hijk"lmnop"}');
^
DETAIL: Unexpected array element.
dvdb=# insert into testarr (arr) values ('{"hijk""lmnop"}');
ERROR: malformed array literal: "{"hijk""lmnop"}"
LINE 1: insert into testarr (arr) values ('{"hijk""lmnop"}');
^
DETAIL: Unexpected array element.
dvdb=# insert into testarr (arr) values ('{"hijk\"lmnop"}');
INSERT 0 1
dvdb=# select * from testarr;
arr
-----------------
{abcdefg}
{"hijk\"lmnop"}
(2 rows)
What I'm looking for is...
{abcdefg}
{hijk"lmnop}
Can this be done ?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2022-11-09 01:38:19 | Re: escaping double-quotes in varchar array |
| Previous Message | Adrian Klaver | 2022-11-09 01:02:31 | Re: "set role" semantics |