SAGA.db_pgsql.6: Execute SQL

Execute SQL commands on a connected PostgreSQL source. Separate different commands with a semicolon (';').

Inputs

Mot de passe

string

Port

integer

Database Name

string

User Name

string

Mot de passe

string

Available Connections

string

Outputs

SQL Statement

transmission

Execution options

successUri
inProgressUri
failedUri

format

mode

Execute End Point

View the execution endpoint of a process.

View the alternative version in HTML.

{"id": "SAGA.db_pgsql.6", "title": "Execute SQL", "description": "Execute SQL commands on a connected PostgreSQL source. Separate different commands with a semicolon (';'). ", "version": "1.0.0", "jobControlOptions": ["sync-execute", "async-execute", "dismiss"], "outputTransmission": ["value", "reference"], "links": [{"rel": "http://www.opengis.net/def/rel/ogc/1.0/execute", "type": "application/json", "title": "Execute End Point", "href": "http://demo.mapmint.com/ogc-api/processes/SAGA.db_pgsql.6/execution"}, {"rel": "alternate", "type": "text/html", "title": "Execute End Point", "href": "http://demo.mapmint.com/ogc-api/processes/SAGA.db_pgsql.6/execution.html"}], "inputs": {"PG_HOST": {"title": "H\u00f4te", "description": "Mot de passe", "schema": {"type": "string", "default": "Any value", "nullable": true}, "id": "PG_HOST"}, "PG_PORT": {"title": "Port", "description": "Port", "schema": {"type": "integer", "default": 5432, "nullable": true}, "id": "PG_PORT"}, "PG_NAME": {"title": "Base de donn\u00e9es", "description": "Database Name", "schema": {"type": "string", "default": "Any value", "nullable": true}, "id": "PG_NAME"}, "PG_USER": {"title": "User", "description": "User Name", "schema": {"type": "string", "default": "Any value", "nullable": true}, "id": "PG_USER"}, "PG_PWD": {"title": "Mot de passe", "description": "Mot de passe", "schema": {"type": "string", "default": "Any value", "nullable": true}, "id": "PG_PWD"}, "CONNECTION": {"title": "Available Connections", "description": "Available Connections", "schema": {"type": "string", "enum": ["Default>"], "nullable": true}, "id": "CONNECTION"}}, "outputs": {"SQL": {"title": "SQL Statement", "description": "SQL Statement", "schema": {"nullable": true}, "id": "SQL"}}}

http://demo.mapmint.com/ogc-apihttp://localhost/ogc-api/processes/SAGA.db_pgsql.6.html
Last modified: Sat Feb 19 15:43:34 CET 2022