Hi, I have a question regarding the postgresql scripting

From: "Mehrab Erfani" <me(at)vuit(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Hi, I have a question regarding the postgresql scripting
Date: 2003-08-28 22:40:37
Message-ID: 000a01c36db5$676227e0$0e01000a@MEHRAB
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
I tried to get answers back from the newsgroup and the mail list of
postgres.org, but wasn't that luck yet.
I did subscribe though under the name NICO, and with the mail add:
nico_king2002(at)yahoo(dot)com
I'd appreciate it if you could answer my question.

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

Nico,
P.S: I hope I am makeing sense.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Wolff III 2003-08-29 02:44:31 Re: Hi, I have a question regarding the postgresql scripting
Previous Message Oleg Bartunov 2003-08-28 21:17:43 Re: plpgsql: Bush becomes a null, can not execute null query