PGSQLConnect()

Argument

Contents

login_info

Connection information for the PGSQL DB

Element

Type

Contents

userID            

String

User identifier

password       

Boolean

User password (unhashed)

server             

Boolean

Server URL

Error Type

Meaning

Error

Connection not established, login info is incorrect or  user does not have access

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