Postgres Pro
Downloads
Home   >   mailing lists

Re: What is the regex for apostraphe in postgres - Mailing list pgsql-sql

From David G. Johnston
Subject Re: What is the regex for apostraphe in postgres
Date
Msg-id CAKFQuwZOUibf_X0xxruXz_PMBhBGCSemRcGNkP3FF8d=9Q6ZAA@mail.gmail.com
Whole thread Raw
List pgsql-sql
Tree view
On Thursday, October 14, 2021, Shaozhong SHI <shishaozhong@gmail.com> wrote:
Can we check whether a text string contains apostraphe ' of not?


Yes.  But if you write the regex using single quotes to denote the literal you need to follow sql literal writing conventions for escaping the single quote inside the literal.  This is documented.

David J.

pgsql-sql by date:

Previous
From: Shaozhong SHI
Date:
Subject: What is the regex for apostraphe in postgres?
Next
From: "Torsten Grust"
Date:
Subject: Re: What is the regex for apostraphe in postgres?