On 6/14/23 11:23, Marc Millas wrote:
Sort of like?: https://pgloader.readthedocs.io/en/latest/ref/csv.html date format column-name [date format 'YYYY-MM-DD HH24-MI-SS.US']
In Postgresql, could you write a simple anonymous procedure that reads the file_fdw table records, does the conversion and then inserts into the destination table? -> one sql line insert as select using the to_date() function with appropriate format.-- Born in Arizona, moved to Babylonia.
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx
