.
Imports existing vector layer in QGIS int a PostGIS database. Before a connection between QGIS and the PostGIS database has to be created (for example with the DB Manager).
Layer to import [vector: any]Database (connection name) [selection]Name of the database connection name (not the database name).
Opções:
Padrão: 0
Schema (schema name) [string]An existing schema of the selected database can be chosen. By feault this is the ‘public’ schema.
Default: public
Table to import to (leave blank to use layer name) [string]Defines a table name for the imported vector file. By default the name of the vector file is chosen.
Padrão: (não definido)
Primary key field [tablefield: any]Opcional.
Sets the primary key field from an existing field in the vector layer.
Geometry column [string]Defines the name for the geometry information of the table.
Padrão: geom
Overwrite [boolean]Sobrescreve tabelas existentes contendo o mesmo nome.
Padrão: True
Create spatial index [boolean]Defines that no spatial index is created. By default a spatial index is created.
Padrão: True
Convert field names to lowercase [boolean]If activated this prevents that the field names of the input vector layer are set to lowercase. By default field names will be lowercase after the import.
Padrão: True
Drop length constraints on character fields [boolean]Activates that the length constraints on character fields are dropped. By default the length constraints are valid.
Padrão: Falso
processing.runalg('qgis:importintopostgis', input, database, schema, tablename, primary_key, geometry_column, overwrite, createindex, lowercase_names, drop_string_length)
Makes it possible to perform a SQL database query on a PostGIS database connected to QGIS.
Database [string]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.
Padrão: (não definido)
SQL query [string]Defines the SQL query, for example ‘create schema test;’.
Padrão: (não definido)
processing.runalg('qgis:postgisexecutesql', database, sql)