CSV Parser, specify date format

bezout

Hello,

 

I'm using COPY with fdelimitedparser. I would like to be able to specify a date or datetime format for some of the columns, since different date columns can have different formats.

 

I can't list all columns like when using COPY without a parser, since I have many files with different column combinations, and I would rather avoid writing a script to generate my copy command for each file.

 

Is there any way to do this ?

 

Additionally, how do I know which parser natively accepts which date format ?

 

Thanks