R: [postgis-users] Help: Postgres+PostGIS on windows

[Paolo PP. Pulli]

Howdy,
maybe you've done before, otherwise:
* Type the following on the command line [MS-DOS prompt]:
        createdb test
        createlang plpgsql test
        ^^^^^^^^^^^^^^^^^^
           IMPORTANT
Then using shp2pgsql like this [always in MS-DOS prompt]
shp2pgsql -c Edifici.shp test.building > building.sql
The new file:
CREATE TABLE "building" (gid serial, "id" int4, "descrizion" varchar);
SELECT AddGeometryColumn('','building','the_geom','-1','MULTIPOLYGON',2);
BEGIN;
INSERT INTO "building" (gid,"id","descrizion",the_geom) VALUES ('0','0','Edificio quadrato',GeometryFromText('MULTIPOLYGON(((-1188420.65771954 8514919.12058201 ,5245929.98996008 7493899.40702806 ,3878148.86425573 3968491.71683234 ,-3981776.47781998 5432595.45702291 ,-1188420.65771954 8514919.12058201 )))',-1) );
...

Paolo

> -----Messaggio originale-----
> Da: Eugen Gass [mailto:gass at intend.de]
> Inviato: mercoledì 19 gennaio 2005 11.27
> A: postgis-users at postgis.refractions.net
> Oggetto: [postgis-users] Help: Postgres+PostGIS on windows
> 
> Hi,
> 
> I'm trying to use Postgres+PostGIS on windows.
> I installed a complete installpackage "postgresql-8.0.0-rc5-3-int.msi".
> It is running fine.
> But I've an using-problem with PostGIS.
> Can someone tell me how I can use funktions like shp2pgsql under this
> releas?
> With pgAdmin3??? or promt??? under tamplate1 it doesn't go!
> 
> Please Help!
> 
> Thanks
> 
> Eugen
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users