AddMSSQLLayer()

Argument

 Type

Contents

map_name  

string

Name of map

layer_name                     

string

Name of layer being exported

file_name   

string

Name of server + database

table_name          

string

Name of table to which layer is being exported

schema_name      

string

Name of schema to which layer is being exported

options

options array

Options array

Option

Type

Contents

Type

string

Type of layer: Line, Point or Area

Error Type

Meaning

Error

Invalid service name, table name or schema name; or failed to log user in with provided credentials; or failed to extract option from options array; or failed to add external layer to map

Not Found

Map view is not found based on provided map name

Function

Summary

AddMSSQLLayerToWorkspace()

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

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 PostgreSQLse the connection with PostgreSQL, if it exists

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