title: Postgres import file that has columns separated by new lines
body: <p>I have a large text file that has one column per row and I want to import this data file into Postgres.</p>
  
  <p>I have a working MySQL script.  </p>
  
  <pre><code> LOAD DATA LOCAL 
          INFILE '/Users/Farmor/data.sql' 
          INTO TABLE tablename 
          COLUMNS TERMINATED BY '\n';
  </code></pre>
  
  <p>How can I translate this into Postgres? I've tried amongst other this command.</p>
  
  <pre><code>COPY tablename
      FROM '/Users/Farmor/data.sql' 
      WITH DELIMITER '\n'
  </code></pre>
  
  <p>However it complains:</p>
  
  <blockquote>
    <p>ERROR: COPY delimiter must be a single one-byte character </p>
  </blockquote>