title: ERROR: missing data for column when using \copy in psql
body: <p>I'm trying to import a .txt file into PostgreSQL. The txt file has 6 columns: </p>
  
  <pre><code>Laboratory_Name Laboratory_ID   Facility    ZIP_Code     City   State
  </code></pre>
  
  <p>And 213 rows.</p>
  
  <p>I'm trying to use <code>\copy</code> to put the contents of this file into a table called <code>doe2</code> in PostgreSQL using this command:</p>
  
  <pre><code>\copy DOE2 FROM '/users/nathangroom/desktop/DOE_inventory5.txt' (DELIMITER(' '))
  </code></pre>
  
  <p>It gives me this error:</p>
  
  <blockquote>
  <pre><code>missing data for column "facility"
  </code></pre>
  </blockquote>
  
  <p>I've looked all around for what to do when encountering this error and nothing has helped. Has anyone else encountered this?</p>