[postgis-users] RE: Problwm with shp2pgsql.exe

[YC Nyon]

When I issue this command:
C:\postgresql\bin>shp2pgsql -c  pm.shp pm Geoprocessing

The output is as follows:
---------------------------------------------------------
create table pm (gid int4 , ID int4);
select AddGeometryColumn('Geoprocessing','pm','the_geom','-1','MULTIPOLYGON',2);

begin;
Insert into pm values('0','0',GeometryFromText('MULTIPOLYGON(((0.194 0.128 ,0.19
4 0.74 ,0.846 0.74 ,0.846 0.128 ,0.194 0.128 )))',-1) );end;

However, when i check, there is no inserts or table structure to the Geoprocessing database.


Then, I tried to generate the sql statements first:
C:\postgresql\bin>shp2pgsql -c  pm.shp pm Geoprocessing > test.sql

and
C:\postgresql\bin>psql -f test.sql -d Geoprocessing

A check shows the table is present. Connection to Arcview via extensions and pgsql2shape dump works fine.
Did I miss some parameters while issueing the shp2pgsql.exe command?


FYI, I am using the native port of Postgresql 7.2.1 

Regards
Nyon





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