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

[Jeff Lounsbury]

The command looks fine, have you tried with other shapefiles? a
different database? Which version of the shp2pgsql are you using??
Can you send the test.sql file you created to me, there should be
something in the sql statements that is wrong or else your database
isn't working so that would narrow down the possible problems as well.
-Jeff

YC Nyon wrote:

> 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 andC:\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 RegardsNyon