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
