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. Thanks for the help everyone, figured it had to be something simple. Shows how new I am at postgres. On Fri, Jul 15, 2011 at 1:44 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Bryan Nelson <shrek@xxxxxxxxxxxxxxxx> writes: >> Tom, the file was created in linunx and is utf-8. Here is the rake >> task that created the table: > >> class CreateGeoData < ActiveRecord::Migration >> def self.up >> create_table :geo_data do |t| >> t.column :zip_code, :text >> t.column :latitude, :float8 >> t.column :longitude, :float8 >> t.column :city, :text >> t.column :state, :text >> t.column :county, :text >> end >> add_index "geo_data", ["zip_code"], :name => "zip_code_optimization" >> end > > Never heard of rake before, but I'm betting that it's doing stuff > behind your back, like including an "id" column in the table definition. > Try looking at the table in psql (\d geo_data), or enabling query > logging on the server so you can see what the actual CREATE TABLE > command sent to the server looks like. > > If there is an extra column or two in the table definition, you'll need > to put a column list into the COPY command, or else include values for > the added column(s) into the CSV file. > > And I'm still thinking there are invisible characters in that first > line... if you can't avoid that, you might add a dummy header line > and use COPY's HEADER option to ignore the first line. > > 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
