Re: [GENERAL] INSERT INTO: string with apostrophe
| От | David G. Johnston |
|---|---|
| Тема | Re: [GENERAL] INSERT INTO: string with apostrophe |
| Дата | |
| Msg-id | CAKFQuwYtZuGu9cqcG5YzKe_ab7nV1jFT3jVJPbXnz8gG6itL8A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [GENERAL] INSERT INTO: string with apostrophe (Rich Shepard <rshepard@appl-ecosys.com>) |
| Список | pgsql-general |
On Thu, 29 Jun 2017, Cachique wrote:That is correct. You can double the single quotes. Another way is to use
the E'...' syntax (i.e., E'O\'Brien'). Or you can use the quote_*
functions (
https://www.postgresql.org/docs/current/static/functions-str ing.html)
Walter,
Thanks for confirming.
I don't know how you'd use the quote_literal with a literal input.
PostgreSQL also offers a feature called dollar-quoting. If you place two dollar signs surrounding an optional string before and after the text.
i.e., $txt$I've got an unescaped quote in me$txt$
These can be nested, and are particularly useful when writing function bodies.
These and more syntax rules can be found here: https://www.postgresql.org/docs/9.6/static/sql-syntax.html In this case section "4.1.2 Constants"
David J.
В списке pgsql-general по дате отправления: