CSV Parser, specify date format



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 ?



Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file