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

[Klein, Markus (MUF)]

-----Ursprüngliche Nachricht-----
Von: Paolo PP. Pulli [mailto:Ppulli at edinform.it]
Gesendet: Mittwoch, 19. Januar 2005 11:46
An: PostGIS Users Discussion
Betreff: R: [postgis-users] Help: Postgres+PostGIS on windows


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

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Diese Mail wurde automatisch vom MUF-Virenscanner geprueft.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050119/4e4868b6/attachment.html>