How do you want your tables names to be created from those filenames?

> -----Original Message-----
> From: Giannis Giakoumidakis [mailto:ggiakoumida...@yahoo.com]
> Sent: Thursday, September 06, 2012 5:19 AM
> To: Pierre Racine; PostGIS Users Discussion
> Subject: Re: [postgis-users] upload a folder of raster files
> 
> Thank you very much!
> 
> I need some extra help with the table name generator
> (public.dem_x_!_rid:~4,2!), I can't understand how it works.
> 
> Note that my filenames have that form: cc00h00m15s, cc00h00m30s,
> cc00h00m45s, cc00h01m00s, ... , cc02h00m00s (hours, minutes, seconds that
> rising every 15 seconds)
> 
> 
> 
> 
> 
> 
> ________________________________
> 
> From: Pierre Racine <pierre.rac...@sbf.ulaval.ca>
> To: Giannis Giakoumidakis <ggiakoumida...@yahoo.com>; PostGIS Users
> Discussion <postgis-users@postgis.refractions.net>
> Sent: Wednesday, September 5, 2012 9:07 PM
> Subject: RE: [postgis-users] upload a folder of raster files
> 
> 
> Here is my answer to that:
> 
> http://geospatialelucubrations.blogspot.ca/2012/09/loading-many-rasters-into-
> separate.html
> 
> Pierre
> 
> > -----Original Message-----
> > From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-
> > boun...@postgis.refractions.net] On Behalf Of Giannis Giakoumidakis
> > Sent: Monday, September 03, 2012 6:12 AM
> > To: PostGIS Users Discussion
> > Subject: [postgis-users] upload a folder of raster files
> >
> > I want to upload to a db a big number of raster files, pe 500, inside a 
> > folder,
> > named in a row (file_1 to file_500), each one to a different table. Any 
> > ideas? A
> > loop or something of the basic: raster2pgsql -s 4236 -I -C -M file_1.tif -F 
> > -t
> > public.demelevation | psql -d gisdb
> >
> > Note that using wildcard (*.tif) doesn't help, I tried but it uploads all 
> > files in one
> > table as different rows.
> >
> > My sql knowledge is bad, so any help would be precious. Thanks.
> 
> 
> 

_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to