From: | Jaume Teixi <teixi(at)6tems(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
Cc: | "Richard T(dot) Robino" <rickspam(at)wavedivision(dot)com>, Stefan Huber <schweinsaug(at)crosswinds(dot)net> |
Subject: | Re: NOSUCCESS: m$ access -> psql howto ? |
Date: | 2001-02-26 10:48:12 |
Message-ID: | 20010226114812.4317581e.teixi@6tems.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-hackers pgsql-sql |
On Sat, 24 Feb 2001 18:48:15 -0800 "Richard T. Robino"
<rickspam(at)wavedivision(dot)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(at)crosswinds(dot)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(at)6tems(dot)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.
> >
From | Date | Subject | |
---|---|---|---|
Next Message | Jaume Teixi | 2001-02-26 13:28:58 | COPY doesn't works when containing '' or '' characters on db |
Previous Message | Peter Schindler | 2001-02-26 08:51:02 | Re: [INTERFACES] IPC Shared Memory (fwd) |
From | Date | Subject | |
---|---|---|---|
Next Message | Zeugswetter Andreas SB | 2001-02-26 11:23:09 | AW: WAL does not recover gracefully from out-of-disk-sp ace |
Previous Message | Marko Kreen | 2001-02-26 10:15:42 | 'postgres -Q' in test/bench |
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2001-02-26 15:01:23 | Re: sum(bool)? |
Previous Message | Clément Soullard | 2001-02-26 10:10:08 | Using a messaging service.... |