[postgis-users] Shp2pgsql problem 2

[Frank Koormann]

Hi,

* Stefan Hahmann <s.hahmann at mapchart.com> [070418 14:08]:
> Oops,
> 
> Sorry actually i did
> 
> shp2pgsql -s 4326 -a -I -D -k myshapefile2.shp public._g24 | psql -d mapdata
> 
> And then i got the error.  (ERROR:  syntax error at or near "2760003221743" at character 1 LINE 1: 2760003221743 4110 0 100000000005583 0 522760200562014 0 0 1...)
> 
> I have copied the lines to http://paste.lisp.org/display/39917

I successfully ran a completed version of your excerpt without errors.

I noticed, that the data row you uploaded is 
522760003221743        4110        0        100000000005583  .........

but your error message states 

syntax error at or near "2760003221743" at character 1 LINE 1:
2760003221743 4110 0 100000000005583 0 522760200562014 0 0 1...)

--> Where is the leading 52?

Have you tried to save to sql commands into a file instead of using a
pipe and then loading via "psql -f" ?

Regards,

        Frank

-- 
Frank Koormann    |   ++49-541-335 08 35    |   http://www.intevation.net/
Intevation GmbH, Osnabrück, DE | Commercial Register Osnabrück, HR B 18998
Managing Directors: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner
PostGIS Support (http://www.intevation.net/geospatial/postgis-support.en.html)