Right, obrigado Alex.
Il 10/26/2018 11:11 AM, Alexandre Neto ha scritto: > Hi Paolo, > > After loading the text as a delimited text layer, If the attributes > are formatted exactly as the destination table, you can GDAL's Import > vector into PostGIS database processing tool, which contains an > "append" option. > > Alexandre Neto > > Paolo Cavallini <cavall...@faunalia.it <mailto:cavall...@faunalia.it>> > escreveu no dia sexta, 26/10/2018 às 09:48: > > yes, thanks. aa bit of a hack, I wish we could have a cleaner > solution; thanks a lot for the suggestion. > > all the best. > > > Il 10/24/2018 10:08 PM, Marco Bernasocchi ha scritto: >> >> Import the new text as csv in qgis anc copy paste it to the gpkg >> layer? >> >> ciao >> >> On 10.10.18 16:18, Paolo Cavallini wrote: >>> >>> Hi Carlo, >>> >>> 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. >>> >>> Thanks. >>> >>> >>> Il 10/10/2018 02:30 PM, Carlo A. Bertelli (Charta s.r.l.) ha >>> scritto: >>>> 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... >>>> c >>>> >>>> On Wed, Oct 10, 2018 at 8:39 AM Paolo Cavallini >>>> <cavall...@faunalia.it <mailto:cavall...@faunalia.it>> wrote: >>>> >>>> Hi all, >>>> >>>> I have a simple problem for which I cannot find a simple >>>> solution: I >>>> have a table in a gpkg, and I have to add often data coming >>>> from text. >>>> Ideally I'd like to paste the text as a new record, having >>>> it parsed >>>> automatically. Currently this only seems possible from an >>>> SQL shell. >>>> Anything I'm overlooking? >>>> >>>> All the best, and thanks. >>>> >>>> -- >>>> Paolo Cavallini - www.faunalia.eu <http://www.faunalia.eu> >>>> QGIS.ORG <http://QGIS.ORG> Chair: >>>> http://planet.qgis.org/planet/user/28/tag/qgis%20board/ >>>> >>>> >>>> _______________________________________________ >>>> QGIS-Developer mailing list >>>> QGIS-Developer@lists.osgeo.org >>>> <mailto:QGIS-Developer@lists.osgeo.org> >>>> List info: >>>> https://lists.osgeo.org/mailman/listinfo/qgis-developer >>>> Unsubscribe: >>>> https://lists.osgeo.org/mailman/listinfo/qgis-developer >>>> >>>> >>>> >>>> -- >>>> >>>> -------------------------------------------------------------------------- >>>> Carlo A. Bertelli >>>> Charta servizi e sistemi per il territorio e la storia >>>> ambientale srl >>>> Dipendenze del palazzo Doria, >>>> vc. alla Chiesa della Maddalena 9/2 16124 Genova >>>> (Italy) >>>> tel./fax +39(0)10 2475439 +39 0108566195 >>>> <tel:+39%20010%20856%206195> mobile:+39 393 1590711 >>>> <tel:+39%20393%20159%200711> >>>> e-mail: berte...@chartasrl.eu >>>> <mailto:berte...@chartasrl.eu> http://www.chartasrl.eu >>>> >>>> -------------------------------------------------------------------------- >>>> >>>> >>>> >>> >>> -- >>> Paolo Cavallini - www.faunalia.eu <http://www.faunalia.eu> >>> QGIS.ORG <http://QGIS.ORG> Chair: >>> http://planet.qgis.org/planet/user/28/tag/qgis%20board/ >>> >>> _______________________________________________ >>> QGIS-Developer mailing list >>> QGIS-Developer@lists.osgeo.org >>> <mailto:QGIS-Developer@lists.osgeo.org> >>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer >>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer >> -- >> Marco Bernasocchi >> QGIS.org Co-chair >> ma...@opengis.ch <mailto:ma...@opengis.ch> >> +41 (0)79 467 24 70 <tel:+41794672470> >> >> OPENGIS.ch Logo <https://www.opengis.ch> >> >> >> _______________________________________________ >> QGIS-Developer mailing list >> QGIS-Developer@lists.osgeo.org >> <mailto:QGIS-Developer@lists.osgeo.org> >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer > > -- > Paolo Cavallini - www.faunalia.eu <http://www.faunalia.eu> > QGIS.ORG <http://QGIS.ORG> Chair: > http://planet.qgis.org/planet/user/28/tag/qgis%20board/ > > _______________________________________________ > QGIS-Developer mailing list > QGIS-Developer@lists.osgeo.org <mailto:QGIS-Developer@lists.osgeo.org> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer > > -- > Alexandre Neto > --------------------- > @AlexNetoGeo > http://sigsemgrilhetas.wordpress.com > http://gisunchained.wordpress.com > > > _______________________________________________ > QGIS-Developer mailing list > QGIS-Developer@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis%20board/
_______________________________________________ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer