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 06BE03A461A for ; Wed, 1 Dec 2004 13:01:36 +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 01634-03 for ; Wed, 1 Dec 2004 13:01:18 +0000 (GMT) Received: from 3times25.net (duck.3times25.net [66.23.211.34]) by svr1.postgresql.org (Postfix) with ESMTP id 884AE3A559B for ; Wed, 1 Dec 2004 13:01:20 +0000 (GMT) Received: from [127.0.0.1] (rhws.home.edu [127.0.0.1]) by 3times25.net (Postfix) with ESMTP id 5BD2B746B5; Wed, 1 Dec 2004 08:01:20 -0500 (EST) Message-ID: <41ADC09F.4020002@3times25.net> Date: Wed, 01 Dec 2004 08:01:19 -0500 From: Geoffrey User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.2) Gecko/20040803 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "H.J. Sanders" Cc: pgsql-admin@postgresql.org Subject: Re: copy References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit 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/9 X-Sequence-Number: 15595 H.J. Sanders wrote: > 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. sed 's/.$//' file > newfile Always test before using, it's off the top of my head.. -- Until later, Geoffrey