Content-Type: multipart/alternative;
 boundary="------------34Ajv4EPV9w0BEgXtH19I4Fl"
Message-ID: <a50a28fa-6f8b-4fd6-caa4-bcb0526fa5a5@quadratum-braccas.com>
Date: Fri, 15 Apr 2022 12:02:57 -0600
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.7.0
Subject: Re: Having issues inserting a string with a ' into a varchar column
Content-Language: en-US
From: Sbob <sbob@quadratum-braccas.com>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
References: <182146b5-7239-9fdb-1a17-2c16f306f76f@quadratum-braccas.com>
In-Reply-To: <182146b5-7239-9fdb-1a17-2c16f306f76f@quadratum-braccas.com>
Archived-At: 
 <https://www.postgresql.org/message-id/a50a28fa-6f8b-4fd6-caa4-bcb0526fa5a5%40quadratum-braccas.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------34Ajv4EPV9w0BEgXtH19I4Fl
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

correction, the quote_ident below should be quote_literal

I did not try quote_ident


On 4/15/22 12:01, Sbob wrote:
>
> Hi all;
>
>
> I have a table that includes a varchar column.
>
> I am inserting some data and one of the strings = "Poker 5 card Hold'Em"
>
> as a straight string it errors out.
>
>
> 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:
>
>
> psql:test.sql:1042: ERROR:  syntax error at or near "Em"
> LINE 1: ...ed) VALUES ( quote_literal('Poker 5 card Hold\\'Em'), 2, 1...
>
>
> Thanks in advance
>
>
>
--------------34Ajv4EPV9w0BEgXtH19I4Fl
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>correction, the quote_ident below should be <span
        style="color:#000000;background-color:#ffffff;">quote_literal</span></p>
    <p><span style="color:#000000;background-color:#ffffff;">I did not
        try </span><span
        style="color:#000000;background-color:#ffffff;">quote_ident</span></p>
    <div class="moz-cite-prefix"><br>
    </div>
    <div class="moz-cite-prefix"><br>
    </div>
    <div class="moz-cite-prefix"><br>
    </div>
    <div class="moz-cite-prefix">On 4/15/22 12:01, Sbob wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:182146b5-7239-9fdb-1a17-2c16f306f76f@quadratum-braccas.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <p>Hi all;</p>
      <p><br>
      </p>
      <p>I have a table that includes a varchar column.</p>
      <p>I am inserting some data and one of the strings = "Poker 5 card
        Hold'Em"</p>
      <p>as a straight string it errors out.</p>
      <p><br>
      </p>
      <p>I tried this :  quote_ident ( 'Poker 5 card Hold'Em')</p>
      <p>but it still error's out</p>
      <p><br>
      </p>
      <p>I also tried :  <span
          style="color:#000000;background-color:#ffffff;">quote_literal('Poker
          5 card Hold\'Em')</span></p>
      <p><span style="color:#000000;background-color:#ffffff;">but it
          also errors out:</span></p>
      <p><span style="color:#000000;background-color:#ffffff;"><br>
        </span></p>
      <p><span style="color:#000000;background-color:#ffffff;"></span><span
          style="font-family:monospace"><span
            style="color:#000000;background-color:#ffffff;">psql:test.sql:1042:
            ERROR:  syntax error at or near "Em" </span><br>
          LINE 1: ...ed) VALUES ( quote_literal('Poker 5 card
          Hold\\'Em'), 2, 1...<br>
          <br>
        </span></p>
      <p><span style="font-family:monospace"><br>
        </span></p>
      <p>Thanks in advance</p>
      <p><span style="font-family:monospace"><br>
        </span></p>
      <p><span style="font-family:monospace"><br>
        </span></p>
    </blockquote>
  </body>
</html>

--------------34Ajv4EPV9w0BEgXtH19I4Fl--