|
hi all, since several days I
try to import some ascii data into my postgresql 8.4 (under Win Vista SP1)
database. I use the copy command
under pgAdmin III. This is some example data (from an UTF-8 encoded textfile): 1| 3.7200001E-01| 1.0000000E+00|S 2| 1.2400000E+00| 1.0000000E+01|S 3| 9.4199997E-01| 1.0000000E+02|S 4| 1.1200000E+00| 1.0000000E+03|S 5| 8.1800002E-01| 1.6667000E+02|M 6| 9.9400002E-01| 2.7780001E+01|H 7| 3.7200001E-01| 2.7779999E+02|H 8| 3.7200001E-01| 1.1570000E+02|D This is the table
structure: CREATE TABLE tableName
( fs_id integer NOT
NULL, fs_sat real NOT
NULL, fs_hval real NOT
NULL, fs_hunit
character(1) NOT NULL ); This is the copy
command: COPY tableName FROM
'C:/Users/postgres/Documents/import_tableName.txt' DELIMITERS '|'; When I execute it I get
the following error message (translated text): Error: invalid input
syntax for integer: »1« CONTEXT: COPY
tableName, row 1, column fs_id: »1« SQL state:22P02 psql tells me that the
client-encoding is utf-8: postgres=# \encoding UTF8 I don’t have this
problem with tables where no integers are in the first column. My question is now:
what's wrong? Where comes this blank in front of the 1 in the error message
from? Thank you very much
for any help! Oliver |
