R/qgis_postgisexecutesql.R
qgis_postgisexecutesql.Rd
QGIS Algorithm provided by QGIS (native c++) PostgreSQL execute SQL (native:postgisexecutesql). Executes a SQL command on a PostgreSQL database.
qgis_postgisexecutesql(
DATABASE = qgisprocess:::qgis_default_value(),
SQL = qgisprocess:::qgis_default_value(),
...,
.complete_output = .complete_output_option(),
.quiet = .quiet_option(),
.messages = .message_option()
)
providerconnection
- Database (connection name). Name of registered database connection.
string
- SQL query. 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.
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
.