<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2652.35">
<TITLE>AW: [postgis-users] Help: Postgres+PostGIS on windows</TITLE>
</HEAD>
<BODY>
<BR>
<BR>
<P><FONT SIZE=2>-----Ursprüngliche Nachricht-----</FONT>
<BR><FONT SIZE=2>Von: Paolo PP. Pulli [<A HREF="mailto:Ppulli@edinform.it">mailto:Ppulli@edinform.it</A>]</FONT>
<BR><FONT SIZE=2>Gesendet: Mittwoch, 19. Januar 2005 11:46</FONT>
<BR><FONT SIZE=2>An: PostGIS Users Discussion</FONT>
<BR><FONT SIZE=2>Betreff: R: [postgis-users] Help: Postgres+PostGIS on windows</FONT>
</P>
<BR>
<P><FONT SIZE=2>Howdy,</FONT>
<BR><FONT SIZE=2>maybe you've done before, otherwise:</FONT>
<BR><FONT SIZE=2>* Type the following on the command line [MS-DOS prompt]:</FONT>
<BR><FONT SIZE=2> createdb test</FONT>
<BR><FONT SIZE=2> createlang plpgsql test</FONT>
<BR><FONT SIZE=2> ^^^^^^^^^^^^^^^^^^</FONT>
<BR><FONT SIZE=2> IMPORTANT</FONT>
<BR><FONT SIZE=2>Then using shp2pgsql like this [always in MS-DOS prompt]</FONT>
<BR><FONT SIZE=2>shp2pgsql -c Edifici.shp test.building > building.sql</FONT>
<BR><FONT SIZE=2>The new file:</FONT>
<BR><FONT SIZE=2>CREATE TABLE "building" (gid serial, "id" int4, "descrizion" varchar);</FONT>
<BR><FONT SIZE=2>SELECT AddGeometryColumn('','building','the_geom','-1','MULTIPOLYGON',2);</FONT>
<BR><FONT SIZE=2>BEGIN;</FONT>
<BR><FONT SIZE=2>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) );</FONT></P>
<P><FONT SIZE=2>...</FONT>
</P>
<P><FONT SIZE=2>Paolo</FONT>
</P>
<P><FONT SIZE=2>> -----Messaggio originale-----</FONT>
<BR><FONT SIZE=2>> Da: Eugen Gass [<A HREF="mailto:gass@intend.de">mailto:gass@intend.de</A>]</FONT>
<BR><FONT SIZE=2>> Inviato: mercoledě 19 gennaio 2005 11.27</FONT>
<BR><FONT SIZE=2>> A: postgis-users@postgis.refractions.net</FONT>
<BR><FONT SIZE=2>> Oggetto: [postgis-users] Help: Postgres+PostGIS on windows</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Hi,</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> I'm trying to use Postgres+PostGIS on windows.</FONT>
<BR><FONT SIZE=2>> I installed a complete installpackage "postgresql-8.0.0-rc5-3-int.msi".</FONT>
<BR><FONT SIZE=2>> It is running fine.</FONT>
<BR><FONT SIZE=2>> But I've an using-problem with PostGIS.</FONT>
<BR><FONT SIZE=2>> Can someone tell me how I can use funktions like shp2pgsql under this</FONT>
<BR><FONT SIZE=2>> releas?</FONT>
<BR><FONT SIZE=2>> With pgAdmin3??? or promt??? under tamplate1 it doesn't go!</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Please Help!</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Thanks</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Eugen</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> _______________________________________________</FONT>
<BR><FONT SIZE=2>> postgis-users mailing list</FONT>
<BR><FONT SIZE=2>> postgis-users@postgis.refractions.net</FONT>
<BR><FONT SIZE=2>> <A HREF="http://postgis.refractions.net/mailman/listinfo/postgis-users" TARGET="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></FONT>
</P>
<P><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>postgis-users mailing list</FONT>
<BR><FONT SIZE=2>postgis-users@postgis.refractions.net</FONT>
<BR><FONT SIZE=2><A HREF="http://postgis.refractions.net/mailman/listinfo/postgis-users" TARGET="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></FONT>
</P>
<FONT SIZE=3><BR>
<BR>
Diese Mail wurde automatisch vom MUF-Virenscanner geprueft.<BR>
</FONT>
</BODY>
</HTML>