Then I would suggest you use the SQL method: -Create a new table creating a unique numeric id per filename (use generate_series()),
-Join this table to the raster table so you get one numeric id per filename and -Use this field when you call SplitTable(). Pierre > -----Original Message----- > From: Giannis Giakoumidakis [mailto:ggiakoumida...@yahoo.com] > Sent: Thursday, September 06, 2012 10:28 AM > To: Pierre Racine; PostGIS Users Discussion > Subject: Re: [postgis-users] upload a folder of raster files > > Anyhow, it's not so important this for me. > > > > The best would be something that reminds the names of the files but it's ok > if it > is as simple as cc001, cc002, cc003, ... etc or whatever it starts from cc > that is > common to all the filenames and then a row of numbers. > > > > > > ________________________________ > > From: Pierre Racine <pierre.rac...@sbf.ulaval.ca> > To: Giannis Giakoumidakis <ggiakoumida...@yahoo.com>; PostGIS Users > Discussion <postgis-users@postgis.refractions.net> > Sent: Thursday, September 6, 2012 5:03 PM > Subject: RE: [postgis-users] upload a folder of raster files > > > 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
