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 |
See Also
| 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 |
| S> |
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" dialog box |
| PGSQLSetSchema() |
Set the name of the database schema to be displayed to the user in the "Open PostgreSQL Table" dialog box |
| PGSQLSetTable() |
Set the name of the table to be displayed to the user in the "Open PostgreSQL Table" dialog box |