Function.ODBC.Connection!ConnectionName.OpenConnectionPostgreSQL

From GAB Help
Jump to: navigation, search

This command checks if the PostgreSQL driver is installed on the machine and opens a connection to a PostgreSQL database.

Syntax

Function.ODBC.Connection!ConnectionName.OpenConnectionPostgreSQL(Server name or IP Address [String], Database name [String], User Name [String], Password [String]) or

Function.ODBC.Connection!connection_name.OpenConnectionPostgreSQL((Server name or IP Address [String], Port [String],Database name [String], User Name [String], Password [String])

Arguments

Connection Name

The name of the connection

Server Name

Name of the server or IP Address

Port

String Default port is 5432

Database Name

String

UserName

String

Password

String

Example

Function.ODBC.Connection!testConnect.OpenConnectionPostgreSQL (“127.0.0.1”, "Postgres",“Master”, master“”)
Function.ODBC.Connection!testConnect.OpenConnectionPostgreSQL (“127.0.0.1”, "9999",Postgres",“Master”, master“”)

Remarks