title: Copying data into array without use of array_agg() in POSTGRESQL
body: <p>I have read only access to a database in which I would like to aggregate string literals that belong to the same key. The Postgres database is not up to date and array_agg() is not supported, but I need them to be in an array for other purposes. I am currently copying data from that database into a csv file, and then need to copy from the csv file to my new database with array column type. </p>
  
  <p>For example, what I have is:</p>
  
  <pre><code>author ... "BOOK1";"BOOK2";"BOOK3"
  </code></pre>
  
  <p>which results in </p>
  
  <pre><code>ERROR:  malformed array literal: "BOOK1"
  DETAIL:  Array value must start with "{" or dimension information.
  </code></pre>
  
  <p>When I try to copy it from the csv to my database.
  How can I can I get this in an array format without array_agg()?</p>