<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi Carlo,</p>
<p>I think I didn't explain my problem well: I have new data coming
as text, and I'm looking for an easy way of appending these to an
existing gpkg table.</p>
<p>Thanks.<br>
</p>
<br>
<div class="moz-cite-prefix">Il 10/10/2018 02:30 PM, Carlo A.
Bertelli (Charta s.r.l.) ha scritto:<br>
</div>
<blockquote type="cite"
cite="mid:CALc8-VJ_+624TjvpzeXy1+Z4BzPh9d=vWnBneo6BnbYMve1vPQ@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<div dir="ltr">What about working on a geometric view with
properly configured rules while on PostgresSQL or with a trigger
on other DBMSs (SQLite too)? It seems the easiest way to avoid
the shell. Maybe there could even be a way with a virtual file
based on internal SQLite... Just a thought...
<div>c</div>
<br>
<div class="gmail_quote">
<div dir="ltr">On Wed, Oct 10, 2018 at 8:39 AM Paolo Cavallini
<<a href="mailto:cavallini@faunalia.it"
moz-do-not-send="true">cavallini@faunalia.it</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">Hi all,<br>
<br>
I have a simple problem for which I cannot find a simple
solution: I<br>
have a table in a gpkg, and I have to add often data coming
from text.<br>
Ideally I'd like to paste the text as a new record, having
it parsed<br>
automatically. Currently this only seems possible from an
SQL shell.<br>
Anything I'm overlooking?<br>
<br>
All the best, and thanks.<br>
<br>
-- <br>
Paolo Cavallini - <a href="http://www.faunalia.eu"
rel="noreferrer" target="_blank" moz-do-not-send="true">www.faunalia.eu</a><br>
<a href="http://QGIS.ORG" rel="noreferrer" target="_blank"
moz-do-not-send="true">QGIS.ORG</a> Chair:<br>
<a
href="http://planet.qgis.org/planet/user/28/tag/qgis%20board/"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://planet.qgis.org/planet/user/28/tag/qgis%20board/</a><br>
<br>
<br>
_______________________________________________<br>
QGIS-Developer mailing list<br>
<a href="mailto:QGIS-Developer@lists.osgeo.org"
target="_blank" moz-do-not-send="true">QGIS-Developer@lists.osgeo.org</a><br>
List info: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-developer"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
Unsubscribe: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-developer"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a></blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail_signature"
data-smartmail="gmail_signature">--------------------------------------------------------------------------<br>
Carlo A. Bertelli<br>
Charta servizi e sistemi per il territorio e la storia
ambientale srl <br>
Dipendenze del palazzo Doria, <br>
vc. alla Chiesa della Maddalena 9/2 16124
Genova (Italy)<br>
tel./fax +39(0)10 2475439 +39 0108566195
mobile:+39 393 1590711<br>
e-mail: <a href="mailto:bertelli@chartasrl.eu"
target="_blank" moz-do-not-send="true">bertelli@chartasrl.eu</a>
<a href="http://www.chartasrl.eu" target="_blank"
moz-do-not-send="true">http://www.chartasrl.eu</a><br>
--------------------------------------------------------------------------<br>
<br>
<br>
<br>
</div>
</div>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Paolo Cavallini - <a class="moz-txt-link-abbreviated" href="http://www.faunalia.eu">www.faunalia.eu</a>
QGIS.ORG Chair:
<a class="moz-txt-link-freetext" href="http://planet.qgis.org/planet/user/28/tag/qgis%20board/">http://planet.qgis.org/planet/user/28/tag/qgis%20board/</a></pre>
</body>
</html>