From: | "John Jeffery" <jepjeffery(at)hotmail(dot)com> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | SuSE 7.1 PostgreSQL COPY |
Date: | 2001-08-20 03:02:52 |
Message-ID: | F217IiGXix4A2DreBBs0000e188@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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
partnum varchar(15)
partdesc varvhar(20)
price money
currency_code char(2)
discount_code char(2)
weight int4
Model_Name char(4)
Package_Qty int4
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Eckermann | 2001-08-20 19:08:39 | Re: SuSE 7.1 PostgreSQL COPY |
Previous Message | Tom Lane | 2001-08-18 21:12:44 | Re: mdopen error |