title: How to import a text file with '|' delimited data to PostgreSQL database?
body: <p>I have a text file with <code>|</code> delimited data that I want to import to a table in PostgreSQL database. PgAdminIII only exports CSV files. I converted the file to a CSV file but still was unsuccessful importing data to PostgreSQL database. It says an error has occurred:</p>
  
  <pre><code>Extradata after last expected column. 
  CONTEXT: COPY &lt;file1&gt;, line1:
  </code></pre>
  
  <p>What I am doing wrong here?</p>