Specifies the behaviour of the TPgConnectionOptions object.
Class
TPgConnection
Syntax
property Options: TPgConnectionOptions;
Remarks
Set the properties of Options to specify the behaviour of a TPgConnectionOptions object.
Descriptions of all options are in the table below.
| Option Name | Description |
|
ApplicationName |
Defines the application name for connecting to the server. This name will be displayed in the pg_stat_activity view and included in CSV log entries. Only printable ASCII characters may be used in the ApplicationName value. Other characters will be replaced with question marks (?). |
|
Charset |
Used to set the character set that PgDAC uses to read and write character data. |
|
CurrentTimeZone |
Specifies the time zone that PgDAC uses when reading and writing timestamp with time zone data. |
|
EnableBCD |
Specifies whether the currency type is enabled. The default value of this option is False. |
|
EnableComposites |
Detects fields of the composite (ROW) type and creates separate fields for each attribute of the composite type. |
|
EnableDomains |
Specifies how fields of the domain type are mapped to a TField with the base domain type. |
|
EnableFMTBCD |
Uses FMTBCD instead of float for large integer numbers to keep precision. |
|
EnableGeometrics |
Specifies how fields of the geometric types are mapped to TPgGeometricField. |
|
EnableNumerics |
Enables the PgNumeric type instead of the float type. |
|
EnablePgArray |
Enables the PgArray type instead of the string type. |
|
EnablePgGis |
Enables the PgGis type instead of the string type. |
|
EnablePgInet |
Specifies whether fields of the Inet data type are mapped to TPgInetField. |
|
EnablePgTimeStamps |
Maps DATE, TIME, and TIMESTAMP fields to TPgDateField, TPgTimeField, and TPgTimeStampField accordingly. |
|
EnablePgVector |
Enables the PgVector type instead of the string type. |
|
ExactTimeZone |
Specifies that PgDAC uses the native PostgreSQL server rules when reading data that includes a time zone. |
|
ImmediateNotices |
Sets the behavior of receiving notices from PostgreSQL. |
|
IPVersion |
Used to specify the Internet Protocol version. |
|
MessagesCharset |
Used to set a character set for PostgreSQL error messages. |
|
MultipleConnections |
Used to enable or disable the creation of an additional internal connection for TPgQuery, when necessary. |
|
UseUnicode |
Used to specify a value indicating whether the UTF8 charset will be used. |
|
UuidWithBraces |
Specifies whether curly braces should be added to GUID values for fields of the UUID type. |
