Thanks Tom that did it :)
James: I'll add those books to my list
I appreciate everyone's help!
On Fri, Jul 15, 2011 at 2:16 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Bryan Nelson <shrek@shreks-place.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
>