title: How to import tables with missing values?
body: <p>I use basketball data tables to get some understanding of Postgres 9.2 &amp; phppgadmin. Therefore I would like to import csv tables into that database. However, I get:</p>
  
  <pre><code>ERROR:  missing data for column "year"
  CONTEXT:  COPY coaches, line 1: ""coachid";"year";"yr_order";"firstname";"lastname";"season_win";"season_loss";"playoff_win";"playoff..."
  </code></pre>
  
  <p>with command:</p>
  
  <pre><code>\copy coaches FROM '/Users/Desktop/Database/NBAPostGres/DataOriginal/coaches_data.csv' DELIMITER ',' CSV;
  </code></pre>
  
  <p>The current table has no missings. So my questions are:</p>
  
  <ol>
  <li><p>What did I wrong and if using a table with missing values?</p></li>
  <li><p>How to import such table or handle such structure generally(also in respect to missing values)?</p></li>
  </ol>
  
  <p>Data structure:</p>
  
  <pre><code> coachid    year    yr_order    firstname   lastname    season_win
   HAMBLFR01  204        2          Frank     Hamblen         10
   RUSSEJO01  1946       1          John      Russell         22
  </code></pre>
  
  <p>I used:</p>
  
  <pre><code> varchar     integer   integer  character    character     integer
  </code></pre>