I am doing the same thing with success:
use my script:
cheers Markus
*************
param 1: name the directory in which the files are located
param2: name of the table in which the files are loaded
*************
more raster2pgHydroalp.sh
#!/bin/bash
# this script imports raster ascii file into postgis
#
isFirst=true;
cd $1;
for i in $(\ls *.asc);
do
echo $i
if $isFirst
then
raster2pgsql -d -s 32632 -C -F $i $2 | sudo su - postgres -c 'psql -d
hydroalp';
isFirst=false
else
raster2pgsql -a -s 32632 -M -F $i $2 | sudo su - postgres -c 'psql -d
hydroalp'
fi
done
cd ..
***********
--
Ph D. Student Markus Innerebner
DIS Research Group - Faculty of Computer Science
Free University Bozen-Bolzano
Dominikanerplatz 3 - Room 211
I - 39100 Bozen
Phone: +39-0471-016143
Mobile: +39-333-9392929
gpg --fingerprint
-------------------------------------
pub 1024D/588F6308 2007-01-09
Key fingerprint = 6948 947E CBD2 89FD E773 E863 914F EB1B 588F 6308
sub 2048g/BF4877D0 2007-01-09
On Sep 11, 2012, at 6:43 PM, Brian Fitzgerald wrote:
> 979903mosaic.sql
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
