pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jaume Teixi <teixi@6tems.com>
To: pgsql-hackers@postgresql.org
To: pgsql-admin@postgresql.org
Cc: Richard T. Robino <rickspam@wavedivision.com>
Cc: Stefan Huber <schweinsaug@crosswinds.net>
Subject: Re: NOSUCCESS: m$ access -> psql howto ?
Date: Mon, 26 Feb 2001 11:48:12 +0100
Message-ID: <20010226114812.4317581e.teixi@6tems.com> (raw)
In-Reply-To: <B6BDB26F.3024%rickspam@wavedivision.com>
References: <20010223120430.7daa8a12.teixi@6tems.com>
	<B6BDB26F.3024%rickspam@wavedivision.com>

On Sat, 24 Feb 2001 18:48:15 -0800 "Richard T. Robino"
<rickspam@wavedivision.com> wrote:
> Use binary type for transferring files via FTP.
it's the same

On Sat, 24 Feb 2001 09:27:43 +0100 Stefan Huber
<schweinsaug@crosswinds.net> 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" <teixi@6tems.com> 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.
> > 



Message-ID: <20010226114812.4317581e.teixi@6tems.com>
Permalink:  ../20010226114812.4317581e.teixi@6tems.com/
Also on:    postgresql.org/message-id/20010226114812.4317581e.teixi@6tems.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: teixi@6tems.com, pgsql-hackers@postgresql.org, pgsql-admin@postgresql.org, rickspam@wavedivision.com, schweinsaug@crosswinds.net
  Subject: Re: NOSUCCESS: m$ access -> psql howto ?
  In-Reply-To: <20010226114812.4317581e.teixi@6tems.com>
  References: <20010223120430.7daa8a12.teixi@6tems.com> <B6BDB26F.3024%rickspam@wavedivision.com> <20010226114812.4317581e.teixi@6tems.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox