title: Trouble inserting value into a TEXT column with Postgres
body: <p>I am getting an error when I try to insert an alphanumeric value into a TEXT column in a Postgres DB. This is the table definition </p>
  
  <p><img src="https://i.stack.imgur.com/xgTOk.png" alt="![enter image description here">]<a href="https://i.stack.imgur.com/xgTOk.png" rel="nofollow noreferrer">1</a></p>
  
  <p>This is the query I am using to insert data into the table</p>
  
  <pre><code>INSERT INTO sensor_data
              (
                  time,
                  i1, i2, i3, i4,
                  i5, i6, i7, i8,
                  mrt,air_temperature,
                  humidity,tvoc, device_id)
          VALUES (to_timestamp(1667595922) AT TIME ZONE 'UTC',
                  41.340000,  26.160000, 25.860000, 26.160000,
                  25.900000, 25.960000, 26.720000, 25.580000,
                  26.085000, 28.065536,
                   55.204773,  40.000000, 1a0032000947363339343638
              );
  </code></pre>
  
  <p>This is the error message I get </p>
  
  <blockquote>
    <p>ERROR:  syntax error at or near "a0032000947363339343638"
    LINE 12:                      55.204773,  40.000000, 1a00320009473633...</p>
  </blockquote>
  
  <p>When I enter this query, it works just fine. </p>
  
  <pre><code>INSERT INTO sensor_data
              (
                  time,
                  i1, i2, i3, i4,
                  i5, i6, i7, i8,
                  mrt,air_temperature,
                  humidity,tvoc, device_id)
          VALUES (to_timestamp(1667595922) AT TIME ZONE 'UTC',
                  41.340000,  26.160000, 25.860000, 26.160000,
                  25.900000, 25.960000, 26.720000, 25.580000,
                  26.085000, 28.065536,
                   55.204773,  40.000000, 10032000947363339343638
              );
  </code></pre>
  
  <p>The only difference between the 2 queries is the device_id value. The insert fails when the value is '1a0032000947363339343638' and work fine when the value is '10032000947363339343638'. </p>
  
  <p>Why would the insert fail when I try to insert '1a0032000947363339343638' even though the data type is a TEXT? And how do I get the table to accept 1a0032000947363339343638' for a device Id? </p>