Re: Fwd: [GENERAL] How to ignore blank lines with file_fdw

2014-04-22 Thread Ian Barwick
On 22/04/14 21:09, Nicklas Avén wrote: Hallo I am struggling to find the best solution to ignore blank lines in csv-file when using file_fdw. A blank line makes the table unreadable. I would like to avoid manipulating the file directly and avoid the need to make a new corrected copy of the fi

Re: [GENERAL] How to ignore blank lines with file_fdw

2014-04-22 Thread Albe Laurenz
Nicklas Avén wrote: > I have also found in an email from 2011 > http://www.postgresql.org/message-id/4e699de6.8010...@gmail.com > > that when force_not_null was implemented in file_fdw the patch also included > "some cosmetic changes > such as removing useless blank lines." That is refering to b

[GENERAL] How to ignore blank lines with file_fdw

2014-04-22 Thread Nicklas Avén
Hallo I am struggling to find the best solution to ignore blank lines in csv-file when using file_fdw. A blank line makes the table unreadable. I would like to avoid manipulating the file directly and avoid the need to make a new corrected copy of the file. I am on Linux so I have found a