title: COPY column order
body: <p>I'm trying to use COPY with HEADER option but my header line in file is in different order than the column order specified in database. 
  Is the column name order necessary in my file ?? </p>
  
  <p>My code is as below:  </p>
  
  <pre><code>COPY table_name (                                  
  SELECT column_name
  FROM information_schema.columns
  WHERE table_schema = 'schema_name'
    AND table_name   = 'table_name'
  
              )                        
         FROM 'file.csv'  
         WITH DELIMITER ',' CSV HEADER;
  </code></pre>
  
  <p>My database table has got a different order from file.csv and i wanted to select the table order and copy data from csv to table.</p>