title: How do I format text array and hstore data in a CSV/TSV file for importing into Postgres
body: <p>I’m trying to import text arrays and hstore values into Postgres from a CSV (actually TSV) spreadsheet, but I keep getting multiples of these two errors:</p>
  <p><code>ERROR: Syntax error near '}' at position 667</code></p>
  <p><code>ERROR: malformed array literal: &quot;&quot;   Detail: Array value must start with &quot;{&quot; or dimension information.</code></p>
  <p>My text arrays look like this: <code>{hello, world}</code></p>
  <p>and my hstore values look like this: <code>{&quot;hello&quot; =&gt; &quot;world&quot;, &quot;goodbye&quot; =&gt; &quot;world&quot;}</code></p>
  <p>I'm not using the <code>COPY</code> command, I'm importing the file either through my IDE (Goland) database navigator or through Postico 2. What is the proper syntax for array and hstore data in a CSV or TSV spreadsheet for importing into Postgres?</p>