SAGA.db_pgsql.15: Import Table from SQL Query
Import a SQL table from a PostgreSQL database.
Execute End Point
View the execution endpoint of a process.
View the alternative version in HTML.
{"id": "SAGA.db_pgsql.15", "title": "Import Table from SQL Query", "description": "Import a SQL table from a PostgreSQL database.", "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://tb17.geolabs.fr:8111/ogc-api/processes/SAGA.db_pgsql.15/execution"}, {"rel": "alternate", "type": "text/html", "title": "Execute End Point", "href": "http://tb17.geolabs.fr:8111/ogc-api/processes/SAGA.db_pgsql.15/execution.html"}], "inputs": {"PG_HOST": {"title": "Host", "description": "Password", "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": "Database", "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": "Password", "description": "Password", "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"}, "TABLES": {"title": "Tables", "description": "Tables", "schema": {"type": "string", "default": "Any value", "nullable": true}, "id": "TABLES"}, "FIELDS": {"title": "Fields", "description": "Fields", "schema": {"type": "string", "default": "Any value", "nullable": true}, "id": "FIELDS"}, "WHERE": {"title": "Where", "description": "Where", "schema": {"type": "string", "default": "Any value", "nullable": true}, "id": "WHERE"}, "GROUP": {"title": "Group by", "description": "Group by", "schema": {"type": "string", "default": "Any value", "nullable": true}, "id": "GROUP"}, "HAVING": {"title": "Having", "description": "Having", "schema": {"type": "string", "default": "Any value", "nullable": true}, "id": "HAVING"}, "ORDER": {"title": "Order by", "description": "Order by", "schema": {"type": "string", "default": "Any value", "nullable": true}, "id": "ORDER"}}, "outputs": {"DISTINCT": {"title": "Distinct", "description": "Distinct", "schema": {"type": "boolean", "default": false, "nullable": true}, "id": "DISTINCT"}}}
Display original data as JSON
http://tb17.geolabs.fr:8111/ogc-api/processes/SAGA.db_pgsql.15.html Last modified: Sat Dec 4 00:09:36 CET 2021