On Thu, Aug 28, 2003 at 14:40:37 -0800,
Mehrab Erfani <me(at)vuit(dot)com> wrote:
>
> I have written a script to import some data into my
> database tables, with the delimiter ','. Now my question
> is sometime the data being sent to my tables might not
> match the data type or be corrupted and I receive an error message.
> One: how could I prevent that?
> Two: how can I divert all my error messages to a log file, where I can see
> the errors later?
> Three: how can I proceed with importing the rest of the data even though
> some are corrupted?
> Thanks
Your script needs to check the data before passing it off to COPY or INSERT.