SAGA.db_pgsql.16: Import Table from SQL Query (GUI)
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.16", "title": "Import Table from SQL Query (GUI)", "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:8119/ogc-api/processes/SAGA.db_pgsql.16/execution"}, {"rel": "alternate", "type": "text/html", "title": "Execute End Point", "href": "http://tb17.geolabs.fr:8119/ogc-api/processes/SAGA.db_pgsql.16/execution.html"}], "inputs": {"PG_HOST": {"title": "Host", "description": "Password", "schema": {"type": "string", "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", "nullable": true}, "id": "PG_NAME"}, "PG_USER": {"title": "User", "description": "User Name", "schema": {"type": "string", "nullable": true}, "id": "PG_USER"}, "PG_PWD": {"title": "Password", "description": "Password", "schema": {"type": "string", "nullable": true}, "id": "PG_PWD"}, "CONNECTION": {"title": "Available Connections", "description": "Available Connections", "schema": {"type": "string", "nullable": true}, "id": "CONNECTION"}, "WHERE": {"title": "Where", "description": "Where", "schema": {"type": "string", "nullable": true}, "id": "WHERE"}, "HAVING": {"title": "Having", "description": "Having", "schema": {"type": "string", "nullable": true}, "id": "HAVING"}, "ORDER": {"title": "Order by", "description": "Order by", "schema": {"type": "string", "nullable": true}, "id": "ORDER"}, "DISTINCT": {"title": "Distinct", "description": "Distinct", "schema": {"type": "boolean", "default": false, "enum": ["true", "false"], "nullable": true}, "id": "DISTINCT"}}, "outputs": {"TABLE": {"title": "Query Result", "description": "Query Result", "extended-schema": {"oneOf": [{"allOf": [{"$ref": "http://zoo-project.org/dl/link.json"}, {"type": "object", "properties": {"type": {"enum": ["text/csv", "text/csv"]}}}]}, {"type": "object", "required": ["value"], "properties": {"value": {"oneOf": [{"type": "string", "contentEncoding": "utf-8", "contentMediaType": "text/csv"}, {"type": "string", "contentEncoding": "base64", "contentMediaType": "text/csv"}]}}}]}, "schema": {"oneOf": [{"type": "string", "contentEncoding": "utf-8", "contentMediaType": "text/csv"}, {"type": "string", "contentEncoding": "base64", "contentMediaType": "text/csv"}]}, "id": "TABLE"}}}
Display original data as JSON
http://tb17.geolabs.fr:8119/ogc-api/processes/SAGA.db_pgsql.16.html Last modified: Sat Feb 19 15:43:34 CET 2022