User guide

DescriptionDefault
Value
Matching
Postgr-
eSQL op-
tion ex-
ists?
ODBC Option
The number of seconds of inactivity before the driver
sends a TCP keepalives packet.
When this option is set to 0, the driver uses the TCP/IP
system default for this setting.
0YesKeepAliveTime
The number of seconds between each TCP keepalive
retransmission.
0YesKeepAliveInterval
The locale to use for error messages.en-USNoLocale
The maximum data length for BYTEA columns, in bytes.255YesMaxBytea
The maximum data length for LONG VARCHAR
columns, in UTF-8 code units.
8190YesMaxLongVarChar
The maximum data length for VARCHAR columns, in
UTF-8 code units.
255YesMaxVarchar
The port to connect to on the Redshift server.
Note
By default, Amazon Redshift uses port 5439.
YesPort
The password to use to connect to the Amazon Redshift
server.
YesPWD or Password
The IP address or hostname of the Amazon Redshift
server.
YesServer or Server-
name
When this option is enabled (1), the driver returns query
results one row at a time. Enable this option if you plan
to query large results and don't want to retrieve the
entire result into memory.
When this option and UseDeclareFetch are both dis-
abled (0), the driver retrieves the entire query result into
memory.
Note
If UseDeclareFetch is enabled (1), then it takes
precedence over SingleRowMode. If Sin-
gleRowMode is enabled (1) and Use-
DeclareFetch is disabled (0), then SingleRow-
Mode takes precedence over UseMultipleState-
ments.
0NoSingleRowMode
The SSL certificate verification mode to use when
connecting. For more information about possible SSL
modes to use, see Using SSL and Server Certificates
in ODBC (p. 159).
requireYesSSLMode
API Version 2012-12-01
156
Amazon Redshift Management Guide
Configuring Connections in Amazon Redshift