COPY command options via JDBC:

-- http://stackoverflow.com/questions/6958965/how-to-copy-a-data-from-file-to-postgresql-using-jdbc

-- http://www.postgresql.org/docs/8.1/static/sql-copy.html

-- this is different from our import b/c the file is directly passed to the server. COPY syntax doesn't seem to allow for arbitrary user mapping of columns. Requires further investigation. COPY does seem to support STDIN so maybe it is possible to dynamically generate COPY statements as opposed to INSERT statements.

This approach might work for postgresql, greenplum, paraccel & redshift