<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.2920.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>When I issue this command:</FONT></DIV>
<DIV><FONT face=Arial size=2>C:\postgresql\bin>shp2pgsql -c pm.shp pm
Geoprocessing</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The output is as follows:</FONT></DIV>
<DIV><FONT face=Arial
size=2>---------------------------------------------------------<BR>create table
pm (gid int4 , ID int4);<BR>select
AddGeometryColumn('Geoprocessing','pm','the_geom','-1','MULTIPOLYGON',2);</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>begin;<BR>Insert into pm
values('0','0',GeometryFromText('MULTIPOLYGON(((0.194 0.128 ,0.19<BR>4 0.74
,0.846 0.74 ,0.846 0.128 ,0.194 0.128 )))',-1) );end;</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>However, when i check, there is no inserts or table
structure to the Geoprocessing database.</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Then, I tried to generate the sql statements
first:</FONT></DIV>
<DIV><FONT face=Arial size=2>C:\postgresql\bin>shp2pgsql -c pm.shp pm
Geoprocessing > test.sql</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>and</FONT></DIV>
<DIV><FONT face=Arial size=2>C:\postgresql\bin>psql -f test.sql -d
Geoprocessing</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>A check shows the table is present. Connection to
Arcview via extensions and pgsql2shape dump works fine.</FONT></DIV>
<DIV><FONT face=Arial size=2>Did I miss some parameters while issueing the
shp2pgsql.exe command?</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>FYI, I am using the native port of Postgresql 7.2.1
</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Regards</FONT></DIV>
<DIV><FONT face=Arial size=2>Nyon</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV></BODY></HTML>