SAGA.db_pgsql.11: List Table Fields

Loads table information from PostgreSQL data source.

Inputs

Password

string

Port

integer

Database Name

string

User Name

string

Password

string

Available Connections

string

Table

string

Verbose

boolean

Outputs

Field Description

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.11", "title": "List Table Fields", "description": "Loads table information from PostgreSQL data source.", "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.11/execution"}, {"rel": "alternate", "type": "text/html", "title": "Execute End Point", "href": "http://tb17.geolabs.fr:8119/ogc-api/processes/SAGA.db_pgsql.11/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": "Table", "description": "Table", "schema": {"type": "string", "nullable": true}, "id": "TABLES"}, "VERBOSE": {"title": "Verbose", "description": "Verbose", "schema": {"type": "boolean", "default": false, "enum": ["true", "false"], "nullable": true}, "id": "VERBOSE"}}, "outputs": {"TABLE": {"title": "Field Description", "description": "Field Description", "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.11.html
Last modified: Sat Feb 19 15:43:34 CET 2022