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

[Jason Mathis]

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 (pierre.racine at sbf.ulaval.ca) 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: 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  

_______________________________________________  
postgis-users mailing list  
postgis-users at lists.osgeo.org  
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140514/53369433/attachment.html>