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
--
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.
Columns Types
---
zip_code - text
lattitude - float8
longitude - float8
city - text
state - text
county - text
Is this the complete table
, 2011 9:04 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Error Importing CSV File
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
Hi Adrian, yes that is the entire table definition.
On Fri, Jul 15, 2011 at 12:30 PM, Adrian Klaver adrian.kla...@gmail.com 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.
Columns Types
] Error Importing CSV File
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
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-general@postgresql.org
Subject: [GENERAL] Error Importing CSV File
I am having problems importing
Bryan Nelson sh...@shreks-place.com writes:
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
with and without 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-general@postgresql.org
Subject: [GENERAL] Error Importing CSV File
I am
...@postgresql.org] On Behalf Of Bryan Nelson
Sent: Friday, July 15, 2011 9:04 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Error Importing CSV File
I am having problems importing a CSV file of sample data for testing
in a web app.
Columns Types
---
zip_code - text
lattitude
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
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.
Do you mean that you are importing the data using something like psql to
use in a web app or that you are testing a web-app that does the import?
Columns Types
Bryan Nelson sh...@shreks-place.com 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
On 07/15/2011 10:42 AM, Steve Crawford wrote:
.
Error Message
-
ERROR: invalid input syntax for integer: 96799
CONTEXT: COPY geo_data, line 1, column id: 96799
If you have given us a correct table layout, there is no column 96799
...
Oops, meant column id.
Cheers,
Steve
--
On Jul 15, 2011, at 11:44 AM, Tom Lane wrote:
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
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
On Friday, July 15, 2011 10:33:34 am Bryan Nelson wrote:
Tom, the file was created in linunx and is utf-8. Here is the rake
task that created the table:
class CreateGeoData ActiveRecord::Migration
ActiveRecord will add an auto-incrementing id column to the table. You will
need
to look at
Bryan Nelson sh...@shreks-place.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
On Jul 15, 2011, at 12:06 PM, Bryan Nelson wrote:
Hi Scott, do you know if it's possible to force it not to create the
extra field?
If you do that, you are going to have to figure out how to get Rails to work
with that table--which is probably far beyond the Rails help you're going to
get on
On: Fri, 15 Jul 2011 13:57:03 -0400, Bryan Nelson
sh...@shreks-place.com
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
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 t...@sss.pgh.pa.us wrote:
Bryan Nelson sh...@shreks-place.com writes:
Tom, rake is a rails command, also after doing a \d geo_data it does
show that it's
Can you show the output of \d geo_data ?
Try 'using' delimiters
Are you doing this as the postgres superuser?
Because COPY can't load from files as a casual user, you need to pipe it to
copy read from stdin.
Simple script below works for me, modified copy statement might help?.
HTH,
21 matches
Mail list logo