[postgis-users] add foreign-key constraint on raster import

[Pierre Racine]

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: postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-
> bounces at lists.osgeo.org] On Behalf Of Max Demars
> Sent: Wednesday, May 14, 2014 10:08 AM
> To: postgis-users at lists.osgeo.org
> 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