Re: [BUGS] bug in 7.4.2, with Handling of Double Quotation Marks - Mailing list pgsql-general

From Tom Lane
Subject Re: [BUGS] bug in 7.4.2, with Handling of Double Quotation Marks
Date
Msg-id 19390.1081228045@sss.pgh.pa.us
Whole thread Raw
List pgsql-general
Alexander S <sasha@in.crimea.ua> writes:
> Instead I can only insert:
> insert into ref_test values (' {here \\"some_text\\"} ');       -- but
> this is not exactly that i want to have.

Unfortunately, that is what the syntax of array literals requires you to
say.

You might find it easier to work with the ARRAY[] constructor syntax.

            regards, tom lane

pgsql-general by date:

Previous
From: David Wheeler
Date:
Subject: pg_autovacuum won't make on FreeBSD
Next
From: Bruce Momjian
Date:
Subject: Re: psql's "\d" and CLUSTER