X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9DA2F3A496D for ; Wed, 1 Dec 2004 12:33:33 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 92048-03 for ; Wed, 1 Dec 2004 12:33:21 +0000 (GMT) Received: from michael.eatserver.nl (michael.eatserver.nl [212.203.14.103]) by svr1.postgresql.org (Postfix) with ESMTP id 7A1DF3A46B2 for ; Wed, 1 Dec 2004 12:33:22 +0000 (GMT) Received: from linux (82-168-44-140-bbxl.xdsl.tiscali.nl [82.168.44.140]) (authenticated (0 bits)) by michael.eatserver.nl (8.11.6/8.11.6/SuSE Linux 0.5) with ESMTP id iB1CXIw12081 for ; Wed, 1 Dec 2004 13:33:18 +0100 From: "H.J. Sanders" To: Subject: copy Date: Wed, 1 Dec 2004 13:33:26 +0100 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Importance: Normal X-Virus-Scanned: by AMaViS-perl11-milter (http://amavis.org/) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/5 X-Sequence-Number: 15591 Hello. We are moving a database from informix to Postgresql. To do so we do an unload from Informix and copy to postgresql. Informix unloads with a delimiter also after the last field in a record. This is no problem when doing a copy to Postgresql 7.2 You get a warning (to many fields) but the copy process continues. In 7.4 however the copy stops . Does anyone know how to proceed the copy or a fast way to remove the last character from the unload files. They are anyhow to big to handle with vi. Many thanks Henk Sanders