<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>I am doing the same thing with success:</div><div><br></div><div>use my script:</div><div><br></div><div>cheers Markus</div><div><br></div><div>*************</div><div>param 1: name the directory in which the files are located</div><div>param2: name of the table in which the files are loaded</div><div>*************</div><div>more raster2pgHydroalp.sh </div><div><div>#!/bin/bash</div><div># this script imports raster ascii file into postgis</div><div># </div><div>isFirst=true;</div><div>cd $1;</div><div><br></div><div>for i in $(\ls *.asc); </div><div> do</div><div> echo $i </div><div> if $isFirst </div><div> then </div><div> raster2pgsql -d -s 32632 -C -F $i $2 | sudo su - postgres -c 'psql -d hydroalp';</div><div> isFirst=false</div><div> else </div><div> raster2pgsql -a -s 32632 -M -F $i $2 | sudo su - postgres -c 'psql -d hydroalp'</div><div> fi</div><div>done</div><div><br></div><div>cd ..</div></div><div><br></div><div>***********</div><div><br></div><div><br></div><br><div apple-content-edited="true">
<div>-- <br>Ph D. Student Markus Innerebner<br><br>DIS Research Group - Faculty of Computer Science<br>Free University Bozen-Bolzano<br><br>Dominikanerplatz 3 - Room 211<br>I - 39100 Bozen<br>Phone: +39-0471-016143<br>Mobile: +39-333-9392929<br><br><br>gpg --fingerprint<br>-------------------------------------<br>pub 1024D/588F6308 2007-01-09<br> Key fingerprint = 6948 947E CBD2 89FD E773 E863 914F EB1B 588F 6308<br>sub 2048g/BF4877D0 2007-01-09<br></div>
</div>
<br><div><div>On Sep 11, 2012, at 6:43 PM, Brian Fitzgerald wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; ">979903mosaic.sql</span></blockquote></div><br></body></html>