On Fri, Jan 6, 2012 at 6:54 PM, Adrian Klaver <adrian.klaver@gmail.com> wrote:
>
> Try:
> copy vl from 'data.txt' WITH CSV DELIMITER '|';
Doesn't work. Can't see what the different in CSV is from a text file.
Same errors are thrown.
> If that doesn't work take a look at pgloader:
> http://pgfoundry.org/projects/pgloader/
Wow, another geeky tool. Hard to find documentation. Archaic
presentation, no simple steps to install and get using. Anyway doesn't
seem to provide the options I need
(http://pgloader.projects.postgresql.org/) --
a) Ability to assign more than one NULL value
b) Ability to ignore lines altogether that have any problem
Really, other databases have mechanisms to ignore "problem lines"
while copying. Does Postgresql allow me to *ignore* lines while
COPYING?