From: | Bryan Nelson <shrek(at)shreks-place(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Error Importing CSV File |
Date: | 2011-07-15 18:51:38 |
Message-ID: | CAF9KfT9ZsetRtMXP0bnvbAT1hLfK6fGXn+omfjLHp5h2ET6Pig@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Brent Wood | 2011-07-15 19:37:34 | Re: Error Importing CSV File |
Previous Message | Scott Ribe | 2011-07-15 18:19:29 | Re: Error Importing CSV File |