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 по дате отправления
От: Jaime Casanova
Дата:
Сообщение: Re: SQL Statement Help Needed
От: Bruce Momjian
Дата:
FAQ