Re: COPY function and error log

Patrick,

> If there function besides COPY that will let me import data from a
> flat
> file and continue if an error occurs?

No. Use a scripting language, such as Perl, PHP, BASH Shellscript, or
VB to do this. It's what scripting languages are designed for.
Heck, you could even use a combo of PgAdminII and MS Access.

If you're not up to doing this, it's a trivial task for a Perl hacker
or PHP wiz. 2 hours work, tops.

>This was a great functionality
> of
> the MS SQL import that would log the offending error row into an
> error log.

When it works. YMMV, but as an ex-certified MSSQL Server admin, DTS
failed as often as it succeeded. I even had MS return my per-incident
fee on a couple of DTS errors because they couldn't fix them ...

-Josh Berkus