From: | James Nobles <james(at)bolshevikhosting(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | invalid input syntax for integer |
Date: | 2005-07-10 19:03:02 |
Message-ID: | 1121022182.10120.8.camel@ip24-250-136-203.bc.dl.cox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I've just created my first table and I'm trying to load date into it via
the \copy command. Each time i get the invalid input syntax, no matter
what the type for the column is set too. I've tried int,integer and now
numeric.
Column | Type | Modifiers
-------------+-----------------------+-----------
county_code | integer |
cntyname | character varying(30) |
\copy fips_codes_county FROM '/var/lib/pgsql/files/county.csv' USING
DELIMITERS ','
This is a sample of the file i'm attempting to load, a simple ascii/csv
file.
cat county.csv|more
county_code,cntyname
1,ANDERSON
3,ANDREWS
5,ANGELINA
7,ARANSAS
9,ARCHER
11,ARMSTRONG
13,ATASCOSA
15,AUSTIN
17,BAILEY
19,BANDERA
21,BASTROP
23,BAYLOR
25,BEE
27,BELL
29,BEXAR
31,BLANCO
thanks...
From | Date | Subject | |
---|---|---|---|
Next Message | Søren Poulsen | 2005-07-10 20:11:00 | Re: relation does not exist!? |
Previous Message | Lucius Seneca | 2005-07-10 15:00:06 | CSV Import? |