Re: Loading data from tab delimited file using COPY - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Loading data from tab delimited file using COPY
Date
Msg-id 20041211034631.GA62930@winnie.fuhr.org
Whole thread Raw
In response to Loading data from tab delimited file using COPY  (Jason Sheets <jsheets@idahoimageworks.com>)
List pgsql-general
On Wed, Dec 08, 2004 at 09:17:12PM -0700, Jason Sheets wrote:

> Sample Data is available at http://www.idahoimageworks.com/sampledata.txt
>
> I'm using the command: COPY residential FROM 'file' WITH DELIMITER AS '\t';
>
> I'm receiving the error: ERROR: missing data for column "builder"
>
> When opened with excel as a tab delimited file all the fields are
> separated correctly, I know this e-mail is pretty long but I'm stumped.

Your sample data has 85 fields but the table has 87 fields, so COPY
complains.  How many fields does Excel say the data has?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Spanning tables
Next
From: "itamar"
Date:
Subject: ERROR: relation "table" does not exist - HELP