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

Reply via email to