Bryan Nelson <shrek(at)shreks-place(dot)com> writes:
> Tom, rake is a rails command, also after doing a \d geo_data it does
> show that it's adding an id column before everything else. I'm
> guessing my best bet is going to be creating the table by hand as I
> have no idea how to tell it not to create the extra field.
No need to abandon your infrastructure; you just have to tell COPY what
columns to expect in the CSV file.
COPY geo_data(zip_code, latitude, longitude, city, state, county) FROM ...
regards, tom lane