PGSQLExportFromQuery()

Summary

Runs an SQL query on the open PGSQL database connection.

 

Syntax

PGSQLExportFromQuery(string qry, string name, string filename, string type)

 

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.

 

 

Example

result = PGSQLExportFromQuery(“SELECT column_name FROM table_name”, “dataview1”, “dataview1”, “MEM”, )   

 

Error Codes

 

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

 

 

See Also

 

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