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@xxxxxxxxxxxxx> wrote: > Bryan Nelson <shrek@xxxxxxxxxxxxxxxx> 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 > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
