I am having problems importing a CSV file of sample data for testing
in a web app.
Columns & Types
---
zip_code - text
lattitude - float8
longitude - float8
city - text
state - text
county - text
Some Sample Data From CSV File
--
96799,-7.209975,-170.77
Hi Adrian, yes that is the entire table definition.
On Fri, Jul 15, 2011 at 12:30 PM, Adrian Klaver wrote:
> On 07/15/2011 09:03 AM, Bryan Nelson wrote:
>>
>> I am having problems importing a CSV file of sample data for testing
>> in a web app.
be
> around text fields. That is the norm for CSV files.
>
> Susan
>
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Bryan Nelson
> Sent: Friday, July 15, 2011 9:04 AM
> To: pgsql-gene
thout quotes.
>>
>> Susan
>>
>> -Original Message-
>> From: pgsql-general-ow...@postgresql.org
>> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Bryan Nelson
>> Sent: Friday, July 15, 2011 9:04 AM
>> To: pgsql-gener
at8
t.column :city, :text
t.column :state, :text
t.column :county, :text
end
add_index "geo_data", ["zip_code"], :name => "zip_code_optimization"
end
def self.down
drop_table :geo_data
end
end
On Fri, Jul 15, 2011 at 1:10 PM, Tom
e, 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 wrote:
> Bryan Nelson writes:
>> Tom, the file was created in linunx and is utf-8. Here is the rake
>> task that created the table:
>
>> class Creat
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 wrote:
> Bryan Nelson writes:
>> Tom, rake is a rails command, also after doing a \d geo_data it does
>> show that it
