--Sorted out

Sharing with the list the solution found.

In a current work process, I need to run several models using the
"processing" as "[OGR] Import into PostGIS" is the only tool that allows
the output of the models do "append" on a table of Postgres / PostGIS, I
had to solve the problem in the script.

Recalling I am using QGIS 2.8

The reference that I used to solve the problem, comes from the same tool in
version 2.14. Clarify that in version 2.14 Import into postgis did not work
if executed within a model, at least not work for me, I believe we have
another bug there.

Returning. The "Import into postgis" (for available connections) works in
ogr2ogrtopostgislist.py file in the ... \ QGIS Wien \ apps \ qgis-ltr \
python \ plugins \ processing \ algs \ gdal

The file in its original version builds the command of ogr2ogr with the
schema parameter "-lco" + schema outside the database configuration
parameters: -> ... -append -nlt MULTILINESTRING -lco SCHEMA = teste_geo ...

I changed the file so that the schema parameter was written into the
connection as follows "active_schema =" + schema -> PG: "host = localhost
port = 5432 dbname = gis password = xxx active_schema=temp

And voila it worked!

Attached the file, marked with # rows that were changed.

I hope that helps someone want to use this tool in their models. I'm using
it's pretty cool.

Best regards.


Frederico dos Santos Soares
55 61 8416 0105

Attachment: ogr2ogrtopostgislist.py
Description: Binary data

Qgis-user mailing list
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to