Re: Inserting string with a " into an array using {} syntax ... possible? - Mailing list pgsql-general

In response to Pavel Stehule <pavel.stehule@gmail.com>:

> Hello
>
> try
> postgres=# SELECT ARRAY['text "for you" some'];
>            array
> ---------------------------
>  {"text \"for you\" some"}
> (1 row)

Thanks, and I'm aware of that, but it doesn't answer the original
question.  The code I'm writing is back-end code that other developers
will use to submit queries.

I don't have the luxury of changing their queries from {} syntax to
[] syntax at runtime.  However, if this is something that can't be
done with {}, I can catch it during data validation and throw a useful
error.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/