1) Write a little script that concatenate the date of each file to its filename. Many filename renaming software can do that (e.g. Better file rename).
2) Load the raster with raster2pgsql.py using the -F option. This will add a column with the filename in the DB. 3) Use the substring() SQL function to extract the date from the filename and then cast it to a date to UPDATE a new date_of_creation column. Pierre > -----Original Message----- > From: [email protected] [mailto:postgis-users- > [email protected]] On Behalf Of maduako ikechukwu > Sent: Thursday, September 15, 2011 5:40 PM > To: [email protected] > Subject: [postgis-users] Temporal image analysis in PostGIS > > Yeah attached as an attribute of the filesystem. > Am asking for a possible insight on how to get the time attribute into the > table > becuase i read timestamps are not allowed on raster tables. > Thanks. > > -- > > Iyke Maduako > > Masters in Geospatial Technologies > [Erasmus-Mundus] > > IfGI - Institute for Geoinformatics > University of Muenster Germany > > Phone: +4915129048460 > > Alternative Email:[email protected] > <mailto:email%[email protected]> > > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
