PGSQLExportFromQuery()

Argument

 Type

Contents

qry

string

SQL query to be run

name             

string

Name of dataview

filename

string

Name of file to which results are written

type

string

Type of data format, e.g. in-memory, csv, database, etc.

Error Type

Meaning

Error

View name is null; or either  filename or type (or both) is null; or type is not a valid type; or query fails to retrieve a result

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