<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt">Thank you very much! <br><br>I need some extra help with the table name generator (public.dem_x_!_rid:~4,2!), I can't understand how it works. <br><br>Note that my filenames have that form: cc00h00m15s, cc00h00m30s, cc00h00m45s, cc00h01m00s, ... , cc02h00m00s (hours, minutes, seconds that rising every 15 seconds)<br><div><br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span><br></span></div><div><br></div> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div style="font-family: times new
roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Pierre Racine <Pierre.Racine@sbf.ulaval.ca><br> <b><span style="font-weight: bold;">To:</span></b> Giannis Giakoumidakis <ggiakoumidakis@yahoo.com>; PostGIS Users Discussion <postgis-users@postgis.refractions.net> <br> <b><span style="font-weight: bold;">Sent:</span></b> Wednesday, September 5, 2012 9:07 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> RE: [postgis-users] upload a folder of raster files<br> </font> </div> <br>
Here is my answer to that:<br><br>http://geospatialelucubrations.blogspot.ca/2012/09/loading-many-rasters-into-separate.html<br><br>Pierre<br><br>> -----Original Message-----<br>> From: <a ymailto="mailto:postgis-users-bounces@postgis.refractions.net" href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a> [mailto:postgis-users-<br>> <a ymailto="mailto:bounces@postgis.refractions.net" href="mailto:bounces@postgis.refractions.net">bounces@postgis.refractions.net</a>] On Behalf Of Giannis Giakoumidakis<br>> Sent: Monday, September 03, 2012 6:12 AM<br>> To: PostGIS Users Discussion<br>> Subject: [postgis-users] upload a folder of raster files<br>> <br>> I want to upload to a db a big number of raster files, pe 500, inside a folder,<br>> named in a row (file_1 to file_500), each one to a different table. Any ideas? A<br>> loop or something of the basic: raster2pgsql -s 4236
-I -C -M file_1.tif -F -t<br>> public.demelevation | psql -d gisdb<br>> <br>> Note that using wildcard (*.tif) doesn't help, I tried but it uploads all files in one<br>> table as different rows.<br>> <br>> My sql knowledge is bad, so any help would be precious. Thanks.<br><br><br><br> </div> </div> </div></body></html>