Hi All,

I have a CSV file where the null values are present as "". I am trying to copy those contents into my postgres table.

My Query is:
COPY table1 FROM 'data.csv' with delimiter ',' csv header null as '';

Error :
ERROR: invalid input syntax for type timestamp: ""
CONTEXT: COPY table1, line 2, column login_dt: ""

where login_dt is a column with type timestamp without time zone.

Guide me how can I load the data properly.

Thanks in advance

One approach is to first import the data into a staging table.

Then, run a query that copies data from the staging table into the final table, using the case construct or the NULLIF function in the select subquery, to insert a null in the target field when the source field is an empty string. (or, more accurately, when the staging table source field contains just the two quotation characters "")