Imports a vector layer currently loaded in QGIS into a PostGIS database. Prior to this a connection between QGIS and the PostGIS database has to be created (for example with the DB Manager).
Name of the database connection (not the database name).
Opciones:
Predeterminado: 0
An existing schema of the selected database can be chosen. By default this is the ‘public’ schema.
Predeterminado: público
Defines a table name for the imported vector file. By default the name of the vector file is chosen.
Por defecto: (no establecer)
Opcional
Sets the primary key field from an existing field in the vector layer.
Defines the name of the geometry column in the new PostGIS table. Geometry information for the features is stored in this column.
Por defecto: geom
Overwrites existing tables having the same name.
Por defecto: True
Specify whether to create a spatial index or not. By default a spatial index is created.
Por defecto: True
If activated this prevents the field names of the input vector layer from being converted to lowercase. By default field names will be lowercase after the import.
Por defecto: True
Specify whether the length constraints on character fields should be dropped or not. By default the length constraints are applied.
Predeterminado: False
processing.runalg('qgis:importintopostgis', input, database, schema, tablename, primary_key, geometry_column, overwrite, createindex, lowercase_names, drop_string_length)
Allows a SQL database query to be performed on a PostGIS database connected to QGIS.
Name of the database, not the connection name. By default you don’t have to fill in the name, the current database connection will be chosen.
Por defecto: (no establecer)
Defines the SQL query, for example ‘create schema test;’.
Por defecto: (no establecer)
processing.runalg('qgis:postgisexecutesql', database, sql)