Received: from island.6tems.com ([195.77.213.6]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1QAjgx60267; Mon, 26 Feb 2001 05:45:43 -0500 (EST) (envelope-from teixi@6tems.com) Received: from thinkpad (studio.6tems.com [195.77.213.230]) by island.6tems.com (8.11.1/8.11.1/Islandmail 8.11.0-6) with SMTP id f1QAgkn21823; Mon, 26 Feb 2001 11:42:46 +0100 X-Authentication-Warning: island.6tems.com: Host studio.6tems.com [195.77.213.230] claimed to be thinkpad Date: Mon, 26 Feb 2001 11:48:12 +0100 From: Jaume Teixi To: pgsql-hackers@postgresql.org, pgsql-admin@postgresql.org Cc: "Richard T. Robino" , Stefan Huber Subject: Re: NOSUCCESS: m$ access -> psql howto ? Message-Id: <20010226114812.4317581e.teixi@6tems.com> In-Reply-To: References: <20010223120430.7daa8a12.teixi@6tems.com> X-Mailer: Sylpheed version 0.4.61 (GTK+ 1.2.8; Linux 2.2.17; i686) Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200102/207 X-Sequence-Number: 814 On Sat, 24 Feb 2001 18:48:15 -0800 "Richard T. Robino" wrote: > Use binary type for transferring files via FTP. it's the same On Sat, 24 Feb 2001 09:27:43 +0100 Stefan Huber wrote: > wild guess: maybe you must escape the pipe-symbol: ...USING DELIMITERS '\|' the same :( finally I managed to export LANG=es_ES on system then on postmaster.ini I also have LANG=es_ES but when I do: COPY products FROM '/var/lib/postgres/dadesi.txt' USING DELIMITERS '|' \g it causes: SELECT edicion FROM products; edicion ----------------- España|Nacional <-------puts on the same cell either there's an '|' in the middle!!! SELECT protagonista FROM products; protagonista ------------------------------ Ferran Adrià|Castellano <-------puts on the same cell el Bulli taller ICC Ferran Adrià|Francés|Francia <-------puts on the same cell 2 '|' Also have tried with @ or tabs as delimiters with any result at all!! why this only occurs on some cells? what more could I check? best regards, jaume. > On 2/23/01 3:04 AM, "Jaume Teixi" wrote: > > > Hi, > > I cannot use any kind of odbc because my customers have his local m$ > > access db's locally then export them on .txt with tab or | separated, then > > put on my server trought ftp. > > > > and is working ok except that the customers are on spanish databases then > > a data like: > > --DATE-----NAME---------LANG------ > > 1/6/2000|Ferran Adrià|Castellano| > > > > when sended trought ftp on my server is converted to: > > --DATE-----NAME------------LANG------ > > 1/6/2000|Ferran Adri\xe0|Castellano| > > > > so when imported on Postgresql with: > > COPY products FROM '/var/lib/postgres/iii2.txt' USING DELIMITERS '|' \g > > --DATE-----NAME-----------------------LANG------ > > 1/6/2000|Ferran Adri\xe0|Castellano|NULL > > > > on the same cell, ignoring the '|' completelly > > > > on 'postmaster.init' I have: LANG=es_ES but doesnt' works... > > using tabulators as a separators also causes same problem... > > > > any pointers to solve this will be really apreciated > > > > the other problem is that if a m$ access database has a return carraige on > > a text cell the import also fails. > > > > > > bests from barcelona, > > teixi. > >