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/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
