PGSQLGetTables()

Argument

 Type

Contents

schema                  

string

Optional, name of the schema of the table, e.g. “public”

Error Type

Meaning

Error

Failed to retrieve a list of database tables

Function

Summary

AddPGSQLLayer()

Add layer to map after exporting it to PGSQL spatial database

AddPGSQLLayerToWorkspace()

Add layer to current workspace after exporting it to PGSQL spatial database

ExportPGSQL()

Export map data to PGSQL spatial database

PGSQLClose()

Close the connection with PostgreSQL, if it exists

PGSQLConnect()

Establish a connection with PostgreSQL 

PGSQLExportFromQuery()

Run an SQL query on the open PGSQL database connection and export results to a file

PGSQLGetDatabases()

Retrieve a list of PGSQL databases from the connected database server

PGSQLGetSchemas()

Retrieve a list of schemas from a PGSQL database

PGSQLGetSpatialDatabases()

Retrieve a list of PGSQL spatial databases from the connected database server

PGSQLGetTables()

Retrieve a list of tables from a PGSQL database

PGSQLGetUniqueFields()

Returns all unique fields from the PGSQL database table, as defined in the table constraints

PGSQLRunQuery()

Run an SQL query on the open PGSQL database connection

PGSQLSetDatabase()

Set database as the current selection in the “Open PostgreSQL Table” dialogue box

PGSQLSetSchema()

Set the name of the database schema to be displayed to the user in the “Open PostgreSQL Table” dialogue box

PGSQLSetTable()

Set the name of the table to be displayed to the user in the “Open PostgreSQL Table” dialogue box