Menu
I have csv file (y.csv) in the folowing format:
's', '1999-10-10', '1999-12-12' 'b', '99-10-10 BC', '1-10-10 BC' 'c', 'NULL', 'NULL' I have a few NULL values (for date) in it which I have indicated through the string 'NULL'.
I am trying to copy the csv file into postgres. For doing so I have created a table:
create table r (id character varying(255), timebegin date, timeend date); Now I am trying to copy the above .csv file into postgres using the command
copy r from '/home/y.csv' delimiter ',' csv; ERROR: invalid input syntax for type date: " 'NULL'" CONTEXT: COPY r, line 1, column timebegin: " 'NULL'" On doing so I am getting an error with NULL. Can someone please help me figure out the error and correct it.
495
Empty Strings and NULL Values In CSV files, a NULL value is typically represented by two successive delimiters (e.g. ,, ) to indicate that the field contains no data; however, you can use string values to denote NULL (e.g. null ) or any unique string.
Example - With INSERT StatementINSERT INTO contacts (first_name, last_name) SELECT first_name, last_name FROM employees WHERE employee_number IS NULL; This PostgreSQL IS NULL example will insert records into the contacts table where the employee_number contains a NULL value.
PostgreSQL databases treat empty strings and NULL as different.
Have you tried it?
copy r from '/home/y.csv' delimiter ',' csv WITH NULL AS 'null'; If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
