I was thinking about this way to do it, but my app has many users, and in case two rasters with the same filename are loaded, there would be a problem using filename to create a foreign key. The aim of the foreign key here would be to specify which user is the owner of which raster.
I suppose I could find a way to handle the possibility of two rasters with the same filename, but if I could create the foreign key during the import, I think that would be the best. On Wed, May 14, 2014 at 11:08 AM, Jason Mathis <[email protected]>wrote: > That what I was thinking too. Just to clarify its a capital â-Fâ. > > Its a handy option for post processing the files in the db. > > http://postgis.net/docs/using_raster_dataman.html#RT_Raster_Loader > > > On May 14, 2014 at 9:04:32 AM, Pierre Racine ([email protected]) > wrote: > > 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 > > > This transmission contains confidential and privileged information > intended solely for the party identified above. If you receive this message > in error, you must not use it or convey it to others. Please destroy it > immediately and contact the sender at (303) 386-3955 or by return e-mail > to the sender. > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > -- 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
