title: create external table with headers in netezza (postgres)
body: <p>I am creating an external table as shown below </p>
  
  <pre><code>CREATE EXTERNAL TABLE '~\test.csv' 
  USING ( DELIMITER ',' Y2BASE 2000 ENCODING 'internal' REMOTESOURCE 'ODBC' ESCAPECHAR '\' )
  AS SELECT * FROM TEST_TABLE;
  </code></pre>
  
  <p>It works fine. My question is :</p>
  
  <p>Is there a way we can name the header values as column names in the test.csv file ? Is it possible in either Netezza or postgres. </p>
  
  <p>I think we can do it using COPY, however I want to do it using the EXTERNAL TABLE command.</p>
  
  <p>Thanks</p>