QGIS Algorithm provided by QGIS (native c++) Export to PostgreSQL (native:importintopostgis). Exports a vector layer to a PostgreSQL database This algorithm exports a vector layer to a PostgreSQL database, creating a new table. Prior to this a connection between QGIS and the PostgreSQL database has to be created (for example through the QGIS Browser panel).
qgis_importintopostgis(
INPUT = qgisprocess:::qgis_default_value(),
DATABASE = qgisprocess:::qgis_default_value(),
SCHEMA = qgisprocess:::qgis_default_value(),
TABLENAME = qgisprocess:::qgis_default_value(),
PRIMARY_KEY = qgisprocess:::qgis_default_value(),
GEOMETRY_COLUMN = qgisprocess:::qgis_default_value(),
ENCODING = qgisprocess:::qgis_default_value(),
OVERWRITE = qgisprocess:::qgis_default_value(),
CREATEINDEX = qgisprocess:::qgis_default_value(),
LOWERCASE_NAMES = qgisprocess:::qgis_default_value(),
DROP_STRING_LENGTH = qgisprocess:::qgis_default_value(),
FORCE_SINGLEPART = qgisprocess:::qgis_default_value(),
...,
.complete_output = .complete_output_option(),
.quiet = .quiet_option(),
.messages = .message_option()
)
source
- Layer to export. Path to a vector layer.
providerconnection
- Database (connection name). Name of registered database connection.
databaseschema
- Schema (schema name). Name of existing database schema.
databasetable
- Table to export to (leave blank to use layer name). Name of existing database table.
field
- Primary key field. The name of an existing field. ; delimited list of existing field names.
string
- Geometry column. String value. field:FIELD_NAME to use a data defined value taken from the FIELD_NAME field. expression:SOME EXPRESSION to use a data defined value calculated using a custom QGIS expression.
string
- Encoding. String value. field:FIELD_NAME to use a data defined value taken from the FIELD_NAME field. expression:SOME EXPRESSION to use a data defined value calculated using a custom QGIS expression.
boolean
- Overwrite. 1 for true/yes. 0 for false/no. field:FIELD_NAME to use a data defined value taken from the FIELD_NAME field. expression:SOME EXPRESSION to use a data defined value calculated using a custom QGIS expression.
boolean
- Create spatial index. 1 for true/yes. 0 for false/no. field:FIELD_NAME to use a data defined value taken from the FIELD_NAME field. expression:SOME EXPRESSION to use a data defined value calculated using a custom QGIS expression.
boolean
- Convert field names to lowercase. 1 for true/yes. 0 for false/no. field:FIELD_NAME to use a data defined value taken from the FIELD_NAME field. expression:SOME EXPRESSION to use a data defined value calculated using a custom QGIS expression.
boolean
- Drop length constraints on character fields. 1 for true/yes. 0 for false/no. field:FIELD_NAME to use a data defined value taken from the FIELD_NAME field. expression:SOME EXPRESSION to use a data defined value calculated using a custom QGIS expression.
boolean
- Create single-part geometries instead of multipart. 1 for true/yes. 0 for false/no. field:FIELD_NAME to use a data defined value taken from the FIELD_NAME field. expression:SOME EXPRESSION to use a data defined value calculated using a custom QGIS expression.
further parameters passed to qgisprocess::qgis_run_algorithm()
logical specifying if complete out of qgisprocess::qgis_run_algorithm()
should be used (TRUE
) or first output (most likely the main) should read (FALSE
). Default value is TRUE
.
logical specifying if parameter .quiet
for qgisprocess::qgis_run_algorithm()
Default value is TRUE
.
logical specifying if messages from qgisprocess::qgis_run_algorithm()
should be printed (TRUE
) or not (FALSE
). Default value is FALSE
.