Re: [GENERAL] Loading data from tab delimited file using COPY

2004-12-10 Thread Michael Fuhr
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" > > Whe

[GENERAL] Loading data from tab delimited file using COPY

2004-12-10 Thread Jason Sheets
Hello everyone, I have had a long term problem loading tab separated data from a text file that has prevented me from migrating my enterprise application from MySQL to PostgreSQL. With version 2 of this application I am making the move to PostgreSQL but am still running into the problem even wi