[postgis-users] Uploading a folder with many files

[Giannis Giakoumidakis]

This works but it loads all different raster data in one table, so in the "raster columns" view it appears only one row about these layers. I dont think this is what I want, because my aim is to load each raster layer in QGIS. Is it possible somehow to load many raster layers at once, everyone in a seperate table?? Thanks.





________________________________
 From: Pierre Racine <Pierre.Racine at sbf.ulaval.ca>
To: Giannis Giakoumidakis <ggiakoumidakis at yahoo.com>; PostGIS Users Discussion <postgis-users at postgis.refractions.net> 
Sent: Thursday, May 10, 2012 5:10 PM
Subject: RE: [postgis-users] Uploading a folder with many files
 
The PostGIS raster loader, raster2pgsql, supports wildcard so you can do:

raster2pgsql -I -C -F c:/temp/*.tif schema.table| psql -U postgres -d batabase

Pierre

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of Giannis Giakoumidakis
> Sent: Thursday, May 10, 2012 5:19 AM
> To: Post GIS Users Discussion
> Subject: [postgis-users] Uploading a folder with many files
> 
> I want to upload to a database a big number of raster files (.tif), for example
> 500, in a folder. They are numbered in a row, for example c001, c002,..., cc500.
> Is there any way to upload all with one command or the whole folder at once, or
> I have to do this one by one? Thanks.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120514/739bd9f6/attachment.html>