Re: help with COPY from .csv file into database

Definitely will do this when I get home from work tonight.
Right now I'm ssh'ing into my box at home, but don't have an X-windows
server installed on my Win-bloze machine here at work. It's too
difficult to edit the .csv file from a console with vim. I need
x-windows so I can run OpenOffice spreadsheet to help see the file
better.

I'm wondering If I may need to reconfigure the fields using CREATE
TABLE, and add NULL to each field. I know that the .csv file
definitely has blank cells scattered throughout that were never filled
in with text or integers. I wonder if subsequent cell data is getting
moved because COPY won't accept empty space between comma separated
values. Or is this not an issue.

Mike

Quoting Oliver Elphick <olly(at)lfix(dot)co(dot)uk>:

>
> Precisely that. Either all the data goes in or none of it does.
>
> Clean up your input file and it will work.
>