title: Can I import CSV data into a table without knowing the columns of the CSV?
body: <p>I have a CSV file <code>file.csv</code>. </p>
  
  <p>In Postgres, I have made a table named <code>grants</code>:</p>
  
  <pre><code>CREATE TABLE grants
  (
  
  )
  WITH (
    OIDS=FALSE
  );
  ALTER TABLE grants
    OWNER TO postgres;
  </code></pre>
  
  <p>I want to import <code>file.csv</code> data without having to specify columns in Postgres.</p>
  
  <p>But if I run <code>COPY grants FROM '/PATH/TO/grants.csv' CSV HEADER;</code>, I get this error: <code>ERROR:  extra data after last expected column</code>.</p>
  
  <p>How do I import the CSV data without having to specify columns and types?</p>