PostgreSQLConnect Class

Summary

Creates a connection to a PostgreSQL database 

 

Constructor

PostgreSQLConnect( array options)

 

Option Name	Type	Contents
Db_Name	String	The name of the Postgres database
NewDBFlag	Boolean	Whether a new database should be created (Default is "False")
ChooseDB	Boolean	Whether a dialog box should be shown for the user to pick the database, and login credentials
NoPooling	Boolean	Whether one or multiple connections area allowed (Default sis "False")

 

Properties

 

Property Name	Type	Contents
dbname	String	The name of the Postgres database
NewDBFlag	Boolean	Whether a new database should be created (Default is "False")
ChooseDB	Boolean	Whether a dialog box should be shown for the user to pick the database, and login credentials
NoPooling	Boolean	Whethe one or multiple connections area allowed (Default sis "False")

 

Methods

 

Open()

Opens the connection

 

Example

pg_opts.db_name =  "My Database"

pg_opts.NewDBFlag = "No"

pg_opts.NoPooling = "True" // we want only one connection so that when we close it, we can delete the db, etc

conn = CreateObject("PostgreSQLConnect", pg_opts)

conn.Open()

 

 

See Also:

AddLayerDB

AddTables

Calculate Tables

Caliper.Charts

CC.ModifyTableOperations

CC.Table

Clustering

Data.Finder

Data.Geocoder

PostgreSQLConnect

PostgreSQLCommand

Routing.Bands

Routing.Path

Routing.Router

Table

Utilities.Mail