Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1O4PWx50030 for ; Fri, 23 Feb 2001 23:25:32 -0500 (EST) (envelope-from pgsql-admin-owner@postgresql.org) Received: from island.6tems.com ([195.77.213.6]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1NB1fx27766; Fri, 23 Feb 2001 06:01:41 -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 f1NAx5S03269; Fri, 23 Feb 2001 11:59:06 +0100 X-Authentication-Warning: island.6tems.com: Host studio.6tems.com [195.77.213.230] claimed to be thinkpad Date: Fri, 23 Feb 2001 12:04:30 +0100 From: Jaume Teixi To: psql-sql , psql-admin Subject: HELP: m$ access -> psql howto ? Message-Id: <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/199 X-Sequence-Number: 804 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.