Postgres Pro
Downloads
Home   >   mailing lists

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

From Rich Shepard
Subject Re: [GENERAL] INSERT INTO: string with apostrophe
Date
Msg-id alpine.LNX.2.11.1706291335180.846@localhost
Whole thread Raw
In response to [GENERAL] INSERT INTO: string with apostrophe  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: [GENERAL] INSERT INTO: string with apostrophe
List pgsql-general
Tree view 
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.

Regards,

Rich

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: [GENERAL] Download 9.6.3 Binaries
Next
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] INSERT INTO: string with apostrophe