| Maptitude GISDK Help |
Runs an SQL query on the open PGSQL database connection.
PGSQLRunQuery(string qry)
| Argument | Type | Contents |
|---|---|---|
| qry | string | SQL query to be run |
PGSQLRunQuery(“SELECT column_name FROM table_name”)
| Error Type | Meaning |
|---|---|
| Error | 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 |
| ©2025 Caliper Corporation | www.caliper.com |