HELP: m$ access -> psql howto ?

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