<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">That what I was thinking too. Just to clarify its a capital “-F”. </div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">Its a handy option for post processing the files in the db. </div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><a href="http://postgis.net/docs/using_raster_dataman.html#RT_Raster_Loader">http://postgis.net/docs/using_raster_dataman.html#RT_Raster_Loader</a></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><p style="color:#000;">On May 14, 2014 at 9:04:32 AM, Pierre Racine (<a href="mailto:pierre.racine@sbf.ulaval.ca">pierre.racine@sbf.ulaval.ca</a>) wrote:</p> <blockquote type="cite" class="clean_bq"><span><div><div></div><div>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.
<br>
<br>Does this works for you?
<br>
<br>Pierre
<br>
<br>> -----Original Message-----
<br>> From: postgis-users-bounces@lists.osgeo.org [mailto:postgis-users-
<br>> bounces@lists.osgeo.org] On Behalf Of Max Demars
<br>> Sent: Wednesday, May 14, 2014 10:08 AM
<br>> To: postgis-users@lists.osgeo.org
<br>> Subject: [postgis-users] add foreign-key constraint on raster import
<br>>
<br>> Hi,
<br>>
<br>>
<br>> I want to import many rasters from files into a same tablewith a foreign-key
<br>> constraint to be able to query them individually or grouped as needed.
<br>>
<br>>
<br>> I was hopping that the raster2pgsql tool would be able to do it, but no
<br>> chance.
<br>>
<br>> Is there a way to ask raster2pgsql to add a foreign-key during import? If
<br>> not, what would be the best approach for this purpose?
<br>>
<br>> Thank you very much,
<br>>
<br>>
<br>> -Max Demars
<br>>
<br>>
<br>> --
<br>>
<br>> Stack Overflow: http://stackoverflow.com/users/1914034/burton449
<br>>
<br>> GIS Overflow: http://gis.stackexchange.com/users/14426/burton449
<br>>
<br>> LastFm: http://www.lastfm.fr/user/burton449
<br>
<br>_______________________________________________
<br>postgis-users mailing list
<br>postgis-users@lists.osgeo.org
<br>http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
<br></div></div></span></blockquote></body></html>
<br>
<p><font face="Arial" size="2">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.</font></p>