X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 16FE0D1B8AC for ; Thu, 28 Aug 2003 17:48:56 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 58877-05 for ; Thu, 28 Aug 2003 14:48:26 -0300 (ADT) Received: from web21303.mail.yahoo.com (web21303.mail.yahoo.com [216.136.129.192]) by svr1.postgresql.org (Postfix) with SMTP id D8FE6D1B8BC for ; Thu, 28 Aug 2003 14:48:24 -0300 (ADT) Message-ID: <20030828174825.70138.qmail@web21303.mail.yahoo.com> Received: from [63.200.221.250] by web21303.mail.yahoo.com via HTTP; Thu, 28 Aug 2003 10:48:25 PDT Date: Thu, 28 Aug 2003 10:48:25 -0700 (PDT) From: Nico King Subject: A question! To: pgsql-docs@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/84 X-Sequence-Number: 1944 Hi, I have writen a script to import some data into my databs tables, with the delimitor ','. Now my question is sometime the data being sent to my tables might not match the data type and I receive an error message. One: how could I prevent that? Two: how can I divert all my error messages to a logfile, where I can see the errors later? Thanks Nico, P.S: I hope I am makeing sense. __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com