title: Importing a csv file into postgresql
body: <p>I have a <code>*.csv</code> file which I want to import into my database. basically it looks like that:</p>
  
  <pre><code>2013.11.07,11:50,1.35163,1.35167,1.35161,1.35163,15
  2013.11.07,11:51,1.35166,1.35173,1.35165,1.35170,21
  2013.11.07,11:52,1.35170,1.35170,1.35163,1.35163,11
  </code></pre>
  
  <p>I am using:</p>
  
  <pre><code>DROP TABLE table;
  
  CREATE TABLE table
  (
  id SERIAL primary key,
  Date Date,
  Time Time,
  Open double precision, 
  High double precision, 
  Low double precision,
  Close double precision,
  Volume bigint
  );
  
  COPY table FROM 'C:\\Users\\user\\EURUSD1.txt' DELIMITER ',' CSV;
  </code></pre>
  
  <p>However I am getting at the Date:</p>
  
  <blockquote>
    <p>ERROR: invalid input syntax for integer: "07/11/2013" CONTEXT: COPY
    eurusd_m1, line 1, column id: "07/11/2013"</p>
  </blockquote>
  
  <p>I really appreciate your help on how to fix that?</p>