Re: Error Importing CSV File

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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
>