how to convert the epoch while loading the data
There is an column timestamp which contains epoch value .
i want to convert the value to human readable format while loading using copy command.
the problem is that when i tried to use to_timestamp(timestamp::int) it works on select query but the same when used in copy command while loading it throws an error as the column name is also timestamp.
the raw data also contains the header with same as below column names
NULL as '\n'
ENCLOSED BY '"'
rejected data as table test.abc_sample_data_rejected