Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

Next:From: Jeff EckermannDate: 2001-08-20 19:08:39
Subject: Re: SuSE 7.1 PostgreSQL COPY
Previous:From: Tom LaneDate: 2001-08-18 21:12:44
Subject: Re: mdopen error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group