[postgis-users] problem with shp2pgsql

henok tadesse bwhenok at yahoo.com
Thu Dec 29 01:39:21 PST 2005


perhaps that was the problem,

the full line is like this...

/usr/local/pgsql/bin/shp2pgsql -s 26911  river.shp
River myschema.myRiverdb > ~/River.sql


and i assumed i should put the shapefiles in the same
folder as the shp2pgsql because i didnot get any hint
where to actually put the shapefiles and i could not
find the 'loader' directory. Where exactly should the
shapefiles be loaded anyway? Or it could be anywhere
given the proper path is provided later in the code? 

thanks

--- Frank Koormann <frank.koormann at intevation.de>
wrote:

> 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/)
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
>
http://postgis.refractions.net/mailman/listinfo/postgis-users
> 



		
___________________________________________________________ 
To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com



More information about the postgis-users mailing list