Re: INSERT INTO: string with apostrophe

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: INSERT INTO: string with apostrophe
Date: 2017-06-29 20:36:39
Message-ID: alpine.LNX.2.11.1706291335180.846@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-string.html)

Walter,

Thanks for confirming.

Regards,

Rich

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2017-06-29 21:04:00 Re: INSERT INTO: string with apostrophe
Previous Message Thomas Kellerer 2017-06-29 20:30:06 Re: Download 9.6.3 Binaries