[postgis-users] Import ESRI shapefiles into PostGIS

[Daniel Grum]

Cort D schrieb:
>  
> Please can somebody tell me how to import my ESRI shapefiles and attribute
> tables into PostGIS.
> I have been trying to use the shp2pgsql function but its either i am not
> using it correctly or its just not working for me.
>
> Please can someone out there help me. I am very new to PostGIS application.
>  
>
>
> Cort wrote:
>   
>> Using shp2pgsql to import a shapefile to PostGIS is a two step process. 
>> First use shp2pgsql to create a *.sql file.  Then use psql to import the
>> information in the *.sql file.   Read the PostGIS docs for specifics on
>> the proper switches (
>> http://postgis.refractions.net/docs/ch04.html#id2537503
>> http://postgis.refractions.net/docs/ch04.html#id2537503 ). 
>>     
Hi,

the text I used for shp2pgsql is:

shp2pgsql.exe -s 31467 C:\...\grenze_by.shp public.grenze_by > grenze_by.sql

You should look what is your EPSG (mine is 31467 for bavaria) and you 
have to change the path where you shape is.

--daniel