:I have the world's dumbest question today. I am running a bash script that
goes through several directories (and each of their several subdirectories) of
shapefiles to run shp2pgsql and put them into the correct PSQL schema and
table. I'd like to be able to set it and forget it, so to speak, but each
time, the shell is prompting me for the user's password. Is there a way to
hardcode the password in?
[4:06pm]
#!/bin/bash
for dir in BG CD CONCITY COUNTY COUSUB LINEARWATER PRIMARYROADS PRISECROADS
RAILS ROADS STATE SUBMCD TABBLOCK
do
ldir="$(echo ${dir} | tr 'A-Z' 'a-z')" >> download.log
shp2pgsql -s 4326 -p ${dir}/tl_2010_01_${ldir}10 public.${ldir} | psql -h
localhost -d geotest -U uname -W pass >> load.log
done
[4:07pm]
Here is the script: http://pastebin.com/prWLzEtk:
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
