[postgis-users] Shp2pgsql problem

[TECHER David]

Hi Steffen

Since you use "> " for "> _g24.sql", you don't have to use "|" after

please use ";" instead of "|"
I mean

usr/local/pgsql/bin/shp2pgsql -s 4326 -i -a -I -D -k theshapefile.shp public._g24 > _g24.sql ;/usr/local/pgsql/bin/psql -d mapdata -f_g24.sql -s

or else without "_g24.sql"

usr/local/pgsql/bin/shp2pgsql -s 4326 -i -a -I -D -k theshapefile.shp public._g24 | /usr/local/pgsql/bin/psql -d mapdata -s



Stefan Hahmann a écrit :
> Hi,
>
> I have the following problem while trying to import a shapefile into
> postgis with shp2psql
>
> I have run this command:
>
>
> /usr/local/pgsql/bin/shp2pgsql -s 4326 -i -a -I -D -k theshapefile.shp
> public._g24 > _g24.sql | /usr/local/pgsql/bin/psql -d mapdata -f
> _g24.sql -s
>
> And got this errormessage:
>
> psql:_g24.sql:743: ERROR:  syntax error at or near "512760001147050" at
> character 1
> psql:_g24.sql:743: LINE 1: 512760001147050 4110 0 512760200017359 0
> 512760200947163 0 0...
> psql:_g24.sql:743:         ^
>
> After googling around and looking the postgis-users forum i could not
> get a solution for that.
>
> I would appreciate any help.
>
> Thanks in advance.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>   


	

	
		
___________________________________________________________________________ 
Yahoo! Mail réinvente le mail ! Découvrez le nouveau Yahoo! Mail et son interface révolutionnaire.
http://fr.mail.yahoo.com