Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] INSERT INTO: string with apostrophe - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] INSERT INTO: string with apostrophe
Date
Msg-id CAKFQuwYtZuGu9cqcG5YzKe_ab7nV1jFT3jVJPbXnz8gG6itL8A@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] INSERT INTO: string with apostrophe  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
Tree view
On Thu, Jun 29, 2017 at 1:36 PM, Rich Shepard <rshepard@appl-ecosys.com> wrote:
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-string.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 by date:

Previous
From: Rich Shepard
Date:
Subject: Re: [GENERAL] INSERT INTO: string with apostrophe
Next
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] duplicate key value violates unique constraint andduplicated records