` `
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).
Options:
Default: 0
An existing schema of the selected database can be chosen. By default this is the ‘public’ schema.
Default: public
Defines a table name for the imported vector file. By default the name of the vector file is chosen.
Default: (not set)
Optional.
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.
Default: geom
Overwrites existing tables having the same name.
Default: True
Specify whether to create a spatial index or not. By default a spatial index is created.
Default: 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.
Default: True
Specify whether the length constraints on character fields should be dropped or not. By default the length constraints are applied.
Default: 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.
Default: (not set)
Defines the SQL query, for example ‘create schema test;’.
Default: (not set)
processing.runalg('qgis:postgisexecutesql', database, sql)