MIME-Version: 1.0
In-Reply-To: <182146b5-7239-9fdb-1a17-2c16f306f76f@quadratum-braccas.com>
References: <182146b5-7239-9fdb-1a17-2c16f306f76f@quadratum-braccas.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Fri, 15 Apr 2022 11:16:31 -0700
Message-ID: 
 <CAKFQuwbzdZ38iZXN9Mp3PEt767b9h-C91evBtAWo8GD_oqatMw@mail.gmail.com>
Subject: Re: Having issues inserting a string with a ' into a varchar column
To: Sbob <sbob@quadratum-braccas.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000f6f12705dcb56854"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwbzdZ38iZXN9Mp3PEt767b9h-C91evBtAWo8GD_oqatMw%40mail.gmail.com>
Precedence: bulk

--000000000000f6f12705dcb56854
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Friday, April 15, 2022, Sbob <sbob@quadratum-braccas.com> wrote:
>
> I tried this :  quote_ident ( 'Poker 5 card Hold'Em')
>
> but it still error's out
>
>
> I also tried :  quote_literal('Poker 5 card Hold\'Em')
>
> but it also errors out:
>
>
You have the right idea you need to escape it.  But guessing isn=E2=80=99t =
a good
method to figure out how.

https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-=
CONSTANTS

You can=E2=80=99t use quote_* on a literal if you do not express the litera=
l
correctly.

David J.

--000000000000f6f12705dcb56854
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Friday, April 15, 2022, Sbob &lt;<a href=3D"mailto:sbob@quadratum-bracca=
s.com">sbob@quadratum-braccas.com</a>&gt; wrote:<blockquote class=3D"gmail_=
quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1=
ex"><div>
    <p>I tried this :=C2=A0 quote_ident ( &#39;Poker 5 card Hold&#39;Em&#39=
;)</p>
    <p>but it still error&#39;s out</p>
    <p><br>
    </p>
    <p>I also tried :=C2=A0 <span style=3D"color:#000000;background-color:#=
ffffff">quote_literal(&#39;Poker
        5 card Hold\&#39;Em&#39;)</span></p>
    <p><span style=3D"color:#000000;background-color:#ffffff">but it also
        errors out:</span></p><p></p></div></blockquote><div><br></div><div=
>You have the right idea you need to escape it.=C2=A0 But guessing isn=E2=
=80=99t a good method to figure out how.</div><div><br></div><div><a href=
=3D"https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYN=
TAX-CONSTANTS">https://www.postgresql.org/docs/current/sql-syntax-lexical.h=
tml#SQL-SYNTAX-CONSTANTS</a></div><div><br></div><div>You can=E2=80=99t use=
 quote_* on a literal if you do not express the literal correctly.</div><di=
v><br></div><div>David J.</div><div>=C2=A0</div>

--000000000000f6f12705dcb56854--