483 lines
6.3 KiB
HTML
483 lines
6.3 KiB
HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
|
|
<HTML>
|
|
<HEAD>
|
|
<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html">
|
|
<TITLE>How to specify as a connection option</TITLE>
|
|
</HEAD>
|
|
<BODY>
|
|
<P STYLE="margin-bottom: 0cm"><FONT FACE="Times New Roman, serif"><FONT SIZE=5>
|
|
<B>How to specify as a connection option </B></FONT></FONT>
|
|
</P>
|
|
<TABLE WIDTH=100% BORDER=1 CELLPADDING=4 CELLSPACING=3 STYLE="page-break-inside: avoid">
|
|
<COL WIDTH=96*>
|
|
<COL WIDTH=80*>
|
|
<COL WIDTH=79*>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
<B><FONT SIZE=4>Definition</FONT></B>
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
<B><FONT SIZE=4>Keyword</FONT></B>
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
<FONT SIZE=4><B>Abbreviation</FONT>
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Data source description
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
Description
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
Nothing
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Name of Server
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
Servername
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
Nothing
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Postmaster listening port
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
Port
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
Nothing
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
User Name
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
Username
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
Nothing
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Password
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
Password
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
Nothing
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Debug flag
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
Debug
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
B2
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Fetch Max Count
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
Fetch
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
A7
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Socket buffer size
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
Socket
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
A8
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Database is read only
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
ReadOnly
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
A0
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Communication to backend logging
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
CommLog
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
B3
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
PostgreSQL backend protocol
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
Protocol
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
A1
|
|
</TD>
|
|
</TR>
|
|
<!-- TR>
|
|
<TD WIDTH=38%>
|
|
Backend genetic optimizer
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
Optimizer
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
B4
|
|
</TD>
|
|
</TR
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Keyset query optimization
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
Ksqo
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
B5
|
|
</TD>
|
|
</TR -->
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Connect Settings (commands sent to backend on connection)
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
ConnSettings
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
A6
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Recognize unique indexes
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
UniqueIndex
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
Nothing
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Unknown result set sizes
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
UnknownSizes
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
A9
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Use Declare/Fetch cursors
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
UseDeclareFetch
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
B6
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Text as LongVarchar
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
TextAsLongVarchar
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
B7
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Unknowns as LongVarchar
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
UnknownsAsLongVarchar
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
B8
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Bools as Char
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
BoolsAsChar
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
B9
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Max Varchar size
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
MaxVarcharSize
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
B0
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Max LongVarchar size
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
MaxLongVarcharSize
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
B1
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Fakes a unique index on OID
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
FakeOidIndex
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
A2
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Includes the OID in SQLColumns
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
ShowOidColumn
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
A3
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Row Versioning
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
RowVersioning
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
A4
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Show SystemTables
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
ShowSystemTables
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
A5
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Parse Statements
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
Parse
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
C0
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
SysTable Prefixes
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
ExtraSysTablePrefixes
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
C2
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Updateable Cursors
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
UpdatableCursors
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
C4
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
LF <-> CR/LF conversion
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
LFConversion
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
C5
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
True is -1
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
TrueIsMinus1
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
C6
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Datatype to report int8 columns as
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
BI
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
Nothing
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Bytea as LO (longVarBinary)
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
ByteaAsLongVarBinary
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
C7
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Use serverside prepare
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
UseServerSidePrepare
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
C8
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Lower case identifier
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
LowerCaseIdentifier
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
C9
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
SSL mode
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
SSLmode
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
CA
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Extra options
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
AB
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
Nothing
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Abbreviate(simple setup of a recommendation value)
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
CX
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
Nothing
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
TCP KEEPALIVE setting: idle time
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
KeepaliveTime
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
D1
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
TCP KEEPALIVE setting: interval
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
KeepaliveInterval
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
D2
|
|
</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD WIDTH=38%>
|
|
Libpq parameters (a conninfo style string e.g. pqopt={sslcert=~/mycert sslkey=~/mykey} enclosed with braces in the case of connection strings)
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
Pqopt
|
|
</TD>
|
|
<TD WIDTH=31%>
|
|
D5
|
|
</TD>
|
|
</TR>
|
|
</TABLE>
|
|
</TABLE>
|
|
<P><BR><BR>
|
|
</P>
|
|
</BODY>
|
|
</HTML>
|