SAGA.db_pgsql.15: Import Table from SQL Query

Import a SQL table from a PostgreSQL database.

Inputs

Password

string

Port

integer

Database Name

string

User Name

string

Password

string

Available Connections

string

Tables

string

Fields

string

Where

string

Group by

string

Having

string

Order by

string

Distinct

boolean

Outputs

Query Result

format
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.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:8119/ogc-api/processes/SAGA.db_pgsql.15/execution"}, {"rel": "alternate", "type": "text/html", "title": "Execute End Point", "href": "http://tb17.geolabs.fr:8119/ogc-api/processes/SAGA.db_pgsql.15/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"}, "TABLES": {"title": "Tables", "description": "Tables", "schema": {"type": "string", "nullable": true}, "id": "TABLES"}, "FIELDS": {"title": "Fields", "description": "Fields", "schema": {"type": "string", "nullable": true}, "id": "FIELDS"}, "WHERE": {"title": "Where", "description": "Where", "schema": {"type": "string", "nullable": true}, "id": "WHERE"}, "GROUP": {"title": "Group by", "description": "Group by", "schema": {"type": "string", "nullable": true}, "id": "GROUP"}, "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"}}}
http://tb17.geolabs.fr:8119/ogc-api/processes/SAGA.db_pgsql.15.html
Last modified: Sat Feb 19 15:43:34 CET 2022