I am trying to import a CSV in PostgreSQL which has one column with datetime2(7) type.
Getting error as below

ERROR: invalid input syntax for type timestamp: “CREATE_S”
CONTEXT: COPY table_s, line 1, column CREATE_S: “CREATE_S”

What should be done to pass the datetime field.

So far, I tried to make the datetime field as character varying and imported successfully.
But, now I am unable to alter the column back to timestamp. Error

ERROR: invalid input syntax for type timestamp: “CREATE_S”
SQL state: 22007

Any help is appreciated. Thanks in advance