title: Postgres - inserting a varchar array via SQL
body: <p>I want to execute this query.</p>
  
  <pre><code>INSERT INTO items (title, description,
  start_date,
  expiration_date,
  type,
  quantity,
  state,
  sold,
  cover_photo_file_name,
  cover_photo_content_type,
  cover_photo_file_size,
  instructions)
  VALUES
  (
      'some_test_value',
      'lorem ipsum',
      '2015-01-01 00:00:00',
      '2015-06-10 00:00:00',
      0,
      19,
      0,
      0,
      'RackMultipart20150317-10093-1ny4gmx.gif',
      'image/gif',
      157574,
      {"lorem ipsum\r","dolor sit\r","loremloremipsumipsum 'sitsit' dolor sit"}
      );
  </code></pre>
  
  <p>I get a very nasty</p>
  
  <pre><code>ERROR: syntax error at or near "{"
  </code></pre>
  
  <p>When i try to do it the</p>
  
  <pre><code>ARRAY["Lorem ipsum\r", ...]
  </code></pre>
  
  <p>I get:</p>
  
  <pre><code>ERROR: column "Lorem ipsum" does not exist
  </code></pre>
  
  <p>The problem is i cannot change the db right now (i don't have time for it) so i need to construct a query that will "do" the job (although this db requires normalization with use of DROP DATABSE... )</p>
  
  <p>What is wrong with my code? Maybe i'm missing something obvious but my tired mind is just skipping it.</p>