I am trying to import a CSV in postgres which has one column with datetime2(7) type.
Getting error as below
1. ERROR: invalid input syntax for type timestamp: "CREATE_S"
2. 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 sucessfully.
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 appreacited. Thanks in advance