ExportPGSQL()

Summary

Export map data to PGSQL spatial database.

Syntax

ExportPGSQL(string layer_bar_set, string service_name, string dbname, char table_name, string schema_name, string uid, string password, array opts)

Argument	Type	Contents
layer_bar_set	string	Name of layer being exported
service_name	string	Name of database server
dbname	string	Name of database to which layer is being exported
table_name	string	Name of table to which layer is being exported
schema_name	string	Name of schema to which layer is being exported
uid	string	Username
password	options array	User password
options	options array	Optional

Option	Type	Contents
Fields	array	Layer fields
Indexed Fields	array	indexed layer fields
[ID Field]	string	Name of layer field used as id
[Layer Name]	string	Name of layer being exported
Database	string	Name of database to which layer is being exported
Owner	string	Name of schema to which layer is being exported
SRID	string	Spatial reference identifier for layer geometry
Table	string	Name of table to which layer is being exported
LogFile	string	Path to log file

Example

opts = {

Fields:[“Field1”,”Field2”},

Indexed Fields:[“Indexed Field1],

ID Field: “ID”,

Layer Name: “My layer”,

Database: “spatial_db1”,

Owner: “public”,

SRID: 4326,

Table: “table_1”,

LogFile: “path\to\log.file”

}

ExportPGSQL(“My Streets”, “localhost”, “spatial_db1”, “table_1”, “public”, “user123”, “pass123”, opts)

Error Codes

Error Type	Meaning
Error	Service name, table name, schema name, user id or user password is null; or failed to extract option from options array; or spatial data conversions/transforms failed

Function	Summary
AddMSSQLLayer()	Add layer to map after exporting it to MSSQL spatial database
AddMSSQLLayerToWorkspace()	Add layer to current workspace after exporting it to MSSQL spatial database
ExportPGSQL()	Export map data to PGSQL 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 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
SPGSQLGetSchemas()	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

ExportPGSQL()

Summary

Syntax

Example

Error Codes

See Also