Giving the following example
copy a_table(name varchar(255), id bigint, creation_date timestamp) from '/tmp/csv.csv' with csv header;
- Specify only the columns he wants to change the datatype from the default (varchar(1000))
- Internally csv2j will make the cast