skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The PostgreSQL Wire Protocol Driver : Connection Option Descriptions
  
Connection Option Descriptions
The following connection option descriptions are listed alphabetically by the GUI name that appears on the driver Setup dialog box. The connection string attribute name, along with its short name, is listed immediately underneath the GUI name.
In most cases, the GUI name and the attribute name are the same; however, some exceptions exist. If you need to look up an option by its connection string attribute name, please refer to the alphabetical table of connection string attribute names.
Also, a few connection string attributes, for example, Password, do not have equivalent options that appear on the GUI. They are in the list of descriptions alphabetically by their attribute names.
The following table lists the connection string attributes supported by the PostgreSQL Wire Protocol driver.
Table 26. PostgreSQL Wire Protocol Attribute Names
Attribute (Short Name)
Default
None
1 (Enabled)
0 (Disabled)
0
3
None
None
None
1 (Enabled)
0 (Disabled)
0 (No Encryption)
0 (Disabled)
0 (Non-Atomic)
0 (Connection)
0 (Disabled)
1 (Enabled)
0 (Disabled)
0 (Disabled)
None
None
4 (ISO 8559-1 Latin-1)
None
None
0 - RowID Columns
None
None
0
0 (Disabled)
15
None
None
None
100
None
0
None
0 (Disabled)
5432
0
0 (Ignore Errors)
1 (Rollback Transaction)
None
None
1 (Enabled)
-10
This section includes the following topics:
* Alternate Servers
* Application Using Threads
* Connection Pooling
* Connection Reset
* Connection Retry Count
* Connection Retry Delay
* Data Source Name
* Database Name
* Description
* Enable Keyset Cursors
* Enable SQLDescribeParam
* Encryption Method
* Extended Column MetaData
* Failover Granularity
* Failover Mode
* Failover Preconnect
* Fetch Ref Cursors
* Fetch TSWTZ as Timestamp
* Fetch TWFS as Time
* Host Name
* Host Name In Certificate
* IANAAppCodePage
* Initialization String
* Key Password
* Key Store
* Key Store Password
* Keyset Cursor Options
* Load Balance Timeout
* Load Balancing
* Login Timeout
* Max Char Size
* Max Long Varchar Size
* Max Pool Size
* Max Varchar Size
* Min Pool Size
* Password
* Port Number
* Query Timeout
* Report Codepage Conversion Errors
* Transaction Error Behavior
* Truststore
* Truststore Password
* User Name
* Validate Server Certificate
* XML Describe Type