Re: [GENERAL] CSV files & empty strings

2009-10-26 Thread Niklas Johansson
On 20 okt 2009, at 16.15, Raymond O'Donnell wrote: On 20/10/2009 05:55, Nate Randall wrote: However, I need some method of "converting" the empty string "" values into NULL values after import, so that I can change the date fields back to date-type. Any suggestions on how this could be acc

Re: [GENERAL] CSV files & empty strings

2009-10-20 Thread Raymond O'Donnell
On 20/10/2009 05:55, Nate Randall wrote: > I am new to Postgre, having formerly used Filemaker Pro. I need to > import CSV files into Postgre which contain some empty string "" values > in several date-type fields. I am able to import the CSV files into > Postgre with the COPY FROM command if the