CSV file - Using COPY Command - Double-Quotes
От
Walter
Тема
CSV file - Using COPY Command - Double-Quotes
Дата
Msg-id
4395C3CE.1050607@thejohnsonplace.com
Список
Дерево обсуждения
Re: CSV file - Using COPY Command - Double-Quotes Mike Ellsworth <nhrcommu@rochester.rr.com>
I have a problem using the copy command on a CSV file. All of the values within the CSV are surrounded with quotation marks. So a null value for a field looks like "" I am trying to import the file and no matter what I do, it hits a null date field and says invalid input syntax for type date : "" How do I get the copy command to simply enter a null value for the "" it finds for the date field in the CSV file? BTW - None of my fields are set as "NOT NULL". They can all accept null values. Please help. Walter PG Noob
В списке pgsql-novice по дате отправления