<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
Even,</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
Appreciate the response.</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
Your example is interesting but there are a couple of issues. Importing a random .000 file using ogr2ogr yields 6 tables in the database. Which tables are created depend on the data and are unknown to me prior to import, so it is difficult to generate the SQL
in advance. This approach does not scale very well if data yields a number of tables.</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
Another issue was when adding the SQL statement for one specific table caused the import to ignore the other 5 tables. Is this the expect result or should all 6 table be imported?</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
Regards, Lars</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
<br>
</div>
<hr tabindex="-1" style="width: 98%; display: inline-block;">
<div id="divRplyFwdMsg" dir="ltr"><font color="#000000" face="Calibri, sans-serif" style="font-size: 11pt;"><b>Fra:</b> Even Rouault <even.rouault@spatialys.com><br>
<b>Sendt:</b> fredag 22. juni 2018 23.15<br>
<b>Til:</b> gdal-dev@lists.osgeo.org<br>
<b>Kopi:</b> Lars<br>
<b>Emne:</b> Re: [gdal-dev] ogr2ogr adding metadata</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size: 11pt;">
<div class="PlainText">On vendredi 22 juin 2018 09:41:02 CEST Lars wrote:<br>
> Hello folks,<br>
> <br>
> Using ogr2ogr (version 2.2.3) to import s57 into PostgreSQL which works<br>
> great.<br>
> <br>
> What is the recommended approach for adding metadata to all inserted data?<br>
> <br>
> Say I wanted to add current date to all inserted data. Does ogr2ogr support<br>
> such operation? Tried using the "-mo" argument but it did not make any<br>
> inpact (same result with argument as without). Ideally I do not want the<br>
> client to be adding this information as a post insert operation (if even<br>
> possible).<br>
<br>
Lars,<br>
<br>
-mo will work only with very few target drivers (I can only think to <br>
GeoPackage actually). This is per-layer/per-table metadata. There's perhaps <br>
the equivalent in PostgreSQL but this isn't implemented by GDAL<br>
<br>
But you can add a column with the current timestamp for example with<br>
<br>
ogr2ogr -update PG:xxxxxx poly.shp \<br>
-sql "SELECT *, CURRENT_TIMESTAMP FROM poly" -dialect SQLITE<br>
<br>
Even<br>
<br>
-- <br>
Spatialys - Geospatial professional services<br>
<a href="http://www.spatialys.com">http://www.spatialys.com</a><br>
</div>
</span></font></div>
</body>
</html>