pg_atoi: error in.....: can't parse..."

From: "stessy" <stessydelcroix(at)tiscali(dot)be>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: pg_atoi: error in.....: can't parse..."
Date: 2003-09-01 07:37:48
Message-ID: 001501c3705b$f1927cf0$9a70eb3e@personnezd2hg1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hi all,

I have this error "pg_atoi: error in "PARC INDUSTRIEL": can't parse "PARC INDUSTRIEL" " when I try to copy data from file to database.

The 2 databases have the same encoding 'LATIN1'.

The data types are all the same in two tables.

These are alls requests I use to copy data.

First database

psql gravoline

CREATE TABLE adr AS SELECT(id_client, rue::text,num::text,"code postal"::text,localite::text) from adresse;

COPY adr to '/usr/adr.sql' USING DELIMITERS '|';

Second database

psql pdg

COPY adresse FROM '/usr/adr.sql' USING DELIMITERS '|';

ps: excuse for my english.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sam Barnett-Cormack 2003-09-01 13:31:36 Prompts in psql
Previous Message Ian Huynh 2003-09-01 03:33:33 Re: Replication