You can add the filename as a new column with the -f option. Then you can extract whatever you want from this column to build a key.
Does this works for you? Pierre > -----Original Message----- > From: [email protected] [mailto:postgis-users- > [email protected]] On Behalf Of Max Demars > Sent: Wednesday, May 14, 2014 10:08 AM > To: [email protected] > Subject: [postgis-users] add foreign-key constraint on raster import > > Hi, > > > I want to import many rasters from files into a same tablewith a foreign-key > constraint to be able to query them individually or grouped as needed. > > > I was hopping that the raster2pgsql tool would be able to do it, but no > chance. > > Is there a way to ask raster2pgsql to add a foreign-key during import? If > not, what would be the best approach for this purpose? > > Thank you very much, > > > -Max Demars > > > -- > > Stack Overflow: http://stackoverflow.com/users/1914034/burton449 > > GIS Overflow: http://gis.stackexchange.com/users/14426/burton449 > > LastFm: http://www.lastfm.fr/user/burton449 _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
