[postgis-users] problem with shp2pgsql

[Frank Koormann]

Just for the records,

* Stephen Woodbridge <woodbri at swoodbridge.com> [051228 21:33]:
> henok tadesse wrote:
> >thanks  every body,
> >
> >i actually have already loaded all the shape files  in the folder where 
> >the shp2pgsql exists.
> >
> >    ./shp2pgsql -s 26911  River.shp River myschema.myRiverdb > River.sql
> >
> >but still it returns >> bash: River.sql: Permission denied
> 
> ./shp2pgsql -s 26911  River.shp River myschema.myRiverdb > ~/River.sql
> 
> >
> >    2) you have only copied the *.shp file to the loader directory, but
> >    not the other associated (and needed fiel). These include at least
> >    *.dbf and *.shx , in many cases also *.sbn, *.prj or *.sbx
> >

the most common way IMHO is not to place your data where your filter
programs are located but to call the filter from where your data is
located, e.g. under /home/myname/mydata :

/usr/lib/postgresql/bin/shp2pgsql -s 26911  River.shp River myschema.myRiverdb > River.sql

If used frequently either copy shp2pgsql to a directory specified in the
PATH environment variable or extend your PATH to the directory where 
shp2pgsql is located.

HTH,

        Frank Koormann

-- 
Frank Koormann                             <frank.koormann at intevation.de>
 Professional Service around Free Software       (http://intevation.net/)
 FreeGIS Project                                 (http://freegis.org/)