Hello from Robertson NSW "Babe Country"
I am trying to do something very simple
Populate a partshistory table with 8 fields from a text, or csv or tab
delimited file which was generated on winme using Fortran90
the fields are
tried COPY from psql with the following;
COPY parthist FROM '/var/lib/pgsql/parthist.txt';
COPY finishes ok but table only imports one field the first one.
Tried tab delimit , comma, blank, pipe. still the same
tried import using pgaccess same result
tried generating file with different order of fields etc
same result only first field gets into table.
Any suggestions ?
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
pgsql-interfaces by date
|Next:||From: Jeff Eckermann||Date: 2001-08-20 19:08:39|
|Subject: Re: SuSE 7.1 PostgreSQL COPY |
|Previous:||From: Tom Lane||Date: 2001-08-18 21:12:44|
|Subject: Re: mdopen error |