SuSE 7.1 PostgreSQL COPY

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

Responses

Browse pgsql-interfaces by date

  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