Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
client_encoding
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the client's character set encoding. |
| Data type | enumeration |
| Default value | UTF8 |
| Allowed values | BIG5,EUC_CN,EUC_JP,EUC_JIS_2004,EUC_KR,EUC_TW,GB18030,GBK,ISO_8859_5,ISO_8859_6,ISO_8859_7,ISO_8859_8,JOHAB,KOI8R,KOI8U,LATIN1,LATIN2,LATIN3,LATIN4,LATIN5,LATIN6,LATIN7,LATIN8,LATIN9,LATIN10,MULE_INTERNAL,SJIS,SHIFT_JIS_2004,SQL_ASCII,UHC,UTF8,WIN866,WIN874,WIN1250,WIN1251,WIN1252,WIN1253,WIN1254,WIN1255,WIN1256,WIN1257,WIN1258 |
| Parameter type | dynamic |
| Documentation | client_encoding |
DateStyle
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the display format for date and time values. Also controls interpretation of ambiguous date inputs. |
| Data type | string |
| Default value | ISO, MDY |
| Allowed values | (ISO|POSTGRES|SQL|GERMAN)(, (DMY|MDY|YMD))? |
| Parameter type | dynamic |
| Documentation | DateStyle |
default_text_search_config
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets default text search configuration. |
| Data type | string |
| Default value | pg_catalog.english |
| Allowed values | [A-Za-z._]+ |
| Parameter type | dynamic |
| Documentation | default_text_search_config |
extra_float_digits
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the number of digits displayed for floating-point values. This affects real, double precision, and geometric data types. A zero or negative parameter value is added to the standard number of digits (FLT_DIG or DBL_DIG as appropriate). Any value greater than zero selects precise output mode. |
| Data type | integer |
| Default value | 1 |
| Allowed values | -15-3 |
| Parameter type | dynamic |
| Documentation | extra_float_digits |
icu_validation_level
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Log level for reporting invalid ICU locale strings. |
| Data type | enumeration |
| Default value | warning |
| Allowed values | warning |
| Parameter type | read-only |
| Documentation | icu_validation_level |
IntervalStyle
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the display format for interval values. |
| Data type | enumeration |
| Default value | postgres |
| Allowed values | postgres,postgres_verbose,sql_standard,iso_8601 |
| Parameter type | dynamic |
| Documentation | IntervalStyle |
lc_messages
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the language in which messages are displayed. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_messages |
lc_monetary
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting monetary amounts. |
| Data type | string |
| Default value | en_US.utf-8 |
| Allowed values | [A-Za-z0-9._ -]+ |
| Parameter type | dynamic |
| Documentation | lc_monetary |
lc_numeric
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting numbers. |
| Data type | string |
| Default value | en_US.utf-8 |
| Allowed values | [A-Za-z0-9._ -]+ |
| Parameter type | dynamic |
| Documentation | lc_numeric |
lc_time
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting date and time values. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_time |
TimeZone
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the time zone for displaying and interpreting time stamps. |
| Data type | string |
| Default value | UTC |
| Allowed values | [A-Za-z0-9/+_-]+ |
| Parameter type | dynamic |
| Documentation | TimeZone |
timezone_abbreviations
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Selects a file of time zone abbreviations. |
| Data type | string |
| Default value | Default |
| Allowed values | Default |
| Parameter type | read-only |
| Documentation | timezone_abbreviations |
client_encoding
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the client-side encoding (character set). The default is to use the database encoding. |
| Data type | enumeration |
| Default value | UTF8 |
| Allowed values | BIG5,EUC_CN,EUC_JP,EUC_JIS_2004,EUC_KR,EUC_TW,GB18030,GBK,ISO_8859_5,ISO_8859_6,ISO_8859_7,ISO_8859_8,JOHAB,KOI8R,KOI8U,LATIN1,LATIN2,LATIN3,LATIN4,LATIN5,LATIN6,LATIN7,LATIN8,LATIN9,LATIN10,MULE_INTERNAL,SJIS,SHIFT_JIS_2004,SQL_ASCII,UHC,UTF8,WIN866,WIN874,WIN1250,WIN1251,WIN1252,WIN1253,WIN1254,WIN1255,WIN1256,WIN1257,WIN1258 |
| Parameter type | dynamic |
| Documentation | client_encoding |
DateStyle
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the display format for date and time values. |
| Data type | string |
| Default value | ISO, MDY |
| Allowed values | (ISO|POSTGRES|SQL|GERMAN)(, (DMY|MDY|YMD))? |
| Parameter type | dynamic |
| Documentation | DateStyle |
default_text_search_config
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Selects the text search configuration that is used by those variants of the text search functions that do not have an explicit argument specifying it. |
| Data type | string |
| Default value | pg_catalog.english |
| Allowed values | [A-Za-z._]+ |
| Parameter type | dynamic |
| Documentation | default_text_search_config |
extra_float_digits
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the number of digits displayed for floating-point values. |
| Data type | integer |
| Default value | 1 |
| Allowed values | -15-3 |
| Parameter type | dynamic |
| Documentation | extra_float_digits |
icu_validation_level
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Log level for reporting invalid ICU locale strings. |
| Data type | enumeration |
| Default value | warning |
| Allowed values | warning |
| Parameter type | read-only |
| Documentation | icu_validation_level |
IntervalStyle
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the display format for interval values. |
| Data type | enumeration |
| Default value | postgres |
| Allowed values | postgres,postgres_verbose,sql_standard,iso_8601 |
| Parameter type | dynamic |
| Documentation | IntervalStyle |
lc_messages
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the language in which messages are displayed. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_messages |
lc_monetary
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting monetary amounts. |
| Data type | string |
| Default value | en_US.utf-8 |
| Allowed values | [A-Za-z0-9._ -]+ |
| Parameter type | dynamic |
| Documentation | lc_monetary |
lc_numeric
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting numbers. |
| Data type | string |
| Default value | en_US.utf-8 |
| Allowed values | [A-Za-z0-9._ -]+ |
| Parameter type | dynamic |
| Documentation | lc_numeric |
lc_time
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting date and time values. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_time |
TimeZone
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the time zone for displaying and interpreting time stamps. |
| Data type | string |
| Default value | UTC |
| Allowed values | [A-Za-z0-9/+_-]+ |
| Parameter type | dynamic |
| Documentation | TimeZone |
timezone_abbreviations
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Selects a file of time zone abbreviations. |
| Data type | string |
| Default value | Default |
| Allowed values | Default |
| Parameter type | read-only |
| Documentation | timezone_abbreviations |
client_encoding
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the client-side encoding (character set). The default is to use the database encoding. |
| Data type | enumeration |
| Default value | UTF8 |
| Allowed values | BIG5,EUC_CN,EUC_JP,EUC_JIS_2004,EUC_KR,EUC_TW,GB18030,GBK,ISO_8859_5,ISO_8859_6,ISO_8859_7,ISO_8859_8,JOHAB,KOI8R,KOI8U,LATIN1,LATIN2,LATIN3,LATIN4,LATIN5,LATIN6,LATIN7,LATIN8,LATIN9,LATIN10,MULE_INTERNAL,SJIS,SHIFT_JIS_2004,SQL_ASCII,UHC,UTF8,WIN866,WIN874,WIN1250,WIN1251,WIN1252,WIN1253,WIN1254,WIN1255,WIN1256,WIN1257,WIN1258 |
| Parameter type | dynamic |
| Documentation | client_encoding |
DateStyle
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the display format for date and time values. |
| Data type | string |
| Default value | ISO, MDY |
| Allowed values | (ISO|POSTGRES|SQL|GERMAN)(, (DMY|MDY|YMD))? |
| Parameter type | dynamic |
| Documentation | DateStyle |
default_text_search_config
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Selects the text search configuration that is used by those variants of the text search functions that do not have an explicit argument specifying it. |
| Data type | string |
| Default value | pg_catalog.english |
| Allowed values | [A-Za-z._]+ |
| Parameter type | dynamic |
| Documentation | default_text_search_config |
extra_float_digits
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the number of digits displayed for floating-point values. |
| Data type | integer |
| Default value | 1 |
| Allowed values | -15-3 |
| Parameter type | dynamic |
| Documentation | extra_float_digits |
icu_validation_level
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Log level for reporting invalid ICU locale strings. |
| Data type | enumeration |
| Default value | warning |
| Allowed values | warning |
| Parameter type | read-only |
| Documentation | icu_validation_level |
IntervalStyle
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the display format for interval values. |
| Data type | enumeration |
| Default value | postgres |
| Allowed values | postgres,postgres_verbose,sql_standard,iso_8601 |
| Parameter type | dynamic |
| Documentation | IntervalStyle |
lc_messages
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the language in which messages are displayed. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_messages |
lc_monetary
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting monetary amounts. |
| Data type | string |
| Default value | en_US.utf-8 |
| Allowed values | [A-Za-z0-9._ -]+ |
| Parameter type | dynamic |
| Documentation | lc_monetary |
lc_numeric
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting numbers. |
| Data type | string |
| Default value | en_US.utf-8 |
| Allowed values | [A-Za-z0-9._ -]+ |
| Parameter type | dynamic |
| Documentation | lc_numeric |
lc_time
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting date and time values. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_time |
TimeZone
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the time zone for displaying and interpreting time stamps. |
| Data type | string |
| Default value | UTC |
| Allowed values | [A-Za-z0-9/+_-]+ |
| Parameter type | dynamic |
| Documentation | TimeZone |
timezone_abbreviations
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Selects a file of time zone abbreviations. |
| Data type | string |
| Default value | Default |
| Allowed values | Default |
| Parameter type | read-only |
| Documentation | timezone_abbreviations |
client_encoding
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the client-side encoding (character set). The default is to use the database encoding. |
| Data type | enumeration |
| Default value | UTF8 |
| Allowed values | BIG5,EUC_CN,EUC_JP,EUC_JIS_2004,EUC_KR,EUC_TW,GB18030,GBK,ISO_8859_5,ISO_8859_6,ISO_8859_7,ISO_8859_8,JOHAB,KOI8R,KOI8U,LATIN1,LATIN2,LATIN3,LATIN4,LATIN5,LATIN6,LATIN7,LATIN8,LATIN9,LATIN10,MULE_INTERNAL,SJIS,SHIFT_JIS_2004,SQL_ASCII,UHC,UTF8,WIN866,WIN874,WIN1250,WIN1251,WIN1252,WIN1253,WIN1254,WIN1255,WIN1256,WIN1257,WIN1258 |
| Parameter type | dynamic |
| Documentation | client_encoding |
DateStyle
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the display format for date and time values. |
| Data type | string |
| Default value | ISO, MDY |
| Allowed values | (ISO|POSTGRES|SQL|GERMAN)(, (DMY|MDY|YMD))? |
| Parameter type | dynamic |
| Documentation | DateStyle |
default_text_search_config
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Selects the text search configuration that is used by those variants of the text search functions that do not have an explicit argument specifying it. |
| Data type | string |
| Default value | pg_catalog.english |
| Allowed values | [A-Za-z._]+ |
| Parameter type | dynamic |
| Documentation | default_text_search_config |
extra_float_digits
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the number of digits displayed for floating-point values. |
| Data type | integer |
| Default value | 1 |
| Allowed values | -15-3 |
| Parameter type | dynamic |
| Documentation | extra_float_digits |
IntervalStyle
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the display format for interval values. |
| Data type | enumeration |
| Default value | postgres |
| Allowed values | postgres,postgres_verbose,sql_standard,iso_8601 |
| Parameter type | dynamic |
| Documentation | IntervalStyle |
lc_messages
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the language in which messages are displayed. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_messages |
lc_monetary
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting monetary amounts. |
| Data type | string |
| Default value | en_US.utf-8 |
| Allowed values | [A-Za-z0-9._ -]+ |
| Parameter type | dynamic |
| Documentation | lc_monetary |
lc_numeric
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting numbers. |
| Data type | string |
| Default value | en_US.utf-8 |
| Allowed values | [A-Za-z0-9._ -]+ |
| Parameter type | dynamic |
| Documentation | lc_numeric |
lc_time
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting date and time values. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_time |
TimeZone
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the time zone for displaying and interpreting time stamps. |
| Data type | string |
| Default value | UTC |
| Allowed values | [A-Za-z0-9/+_-]+ |
| Parameter type | dynamic |
| Documentation | TimeZone |
timezone_abbreviations
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Selects a file of time zone abbreviations. |
| Data type | string |
| Default value | Default |
| Allowed values | Default |
| Parameter type | read-only |
| Documentation | timezone_abbreviations |
client_encoding
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the client-side encoding (character set). The default is to use the database encoding. |
| Data type | enumeration |
| Default value | UTF8 |
| Allowed values | BIG5,EUC_CN,EUC_JP,EUC_JIS_2004,EUC_KR,EUC_TW,GB18030,GBK,ISO_8859_5,ISO_8859_6,ISO_8859_7,ISO_8859_8,JOHAB,KOI8R,KOI8U,LATIN1,LATIN2,LATIN3,LATIN4,LATIN5,LATIN6,LATIN7,LATIN8,LATIN9,LATIN10,MULE_INTERNAL,SJIS,SHIFT_JIS_2004,SQL_ASCII,UHC,UTF8,WIN866,WIN874,WIN1250,WIN1251,WIN1252,WIN1253,WIN1254,WIN1255,WIN1256,WIN1257,WIN1258 |
| Parameter type | dynamic |
| Documentation | client_encoding |
DateStyle
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the display format for date and time values. |
| Data type | string |
| Default value | ISO, MDY |
| Allowed values | (ISO|POSTGRES|SQL|GERMAN)(, (DMY|MDY|YMD))? |
| Parameter type | dynamic |
| Documentation | DateStyle |
default_text_search_config
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Selects the text search configuration that is used by those variants of the text search functions that do not have an explicit argument specifying it. |
| Data type | string |
| Default value | pg_catalog.english |
| Allowed values | [A-Za-z._]+ |
| Parameter type | dynamic |
| Documentation | default_text_search_config |
extra_float_digits
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the number of digits displayed for floating-point values. |
| Data type | integer |
| Default value | 1 |
| Allowed values | -15-3 |
| Parameter type | dynamic |
| Documentation | extra_float_digits |
IntervalStyle
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the display format for interval values. |
| Data type | enumeration |
| Default value | postgres |
| Allowed values | postgres,postgres_verbose,sql_standard,iso_8601 |
| Parameter type | dynamic |
| Documentation | IntervalStyle |
lc_messages
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the language in which messages are displayed. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_messages |
lc_monetary
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting monetary amounts. |
| Data type | string |
| Default value | en_US.utf-8 |
| Allowed values | [A-Za-z0-9._ -]+ |
| Parameter type | dynamic |
| Documentation | lc_monetary |
lc_numeric
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting numbers. |
| Data type | string |
| Default value | en_US.utf-8 |
| Allowed values | [A-Za-z0-9._ -]+ |
| Parameter type | dynamic |
| Documentation | lc_numeric |
lc_time
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting date and time values. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_time |
TimeZone
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the time zone for displaying and interpreting time stamps. |
| Data type | string |
| Default value | UTC |
| Allowed values | [A-Za-z0-9/+_-]+ |
| Parameter type | dynamic |
| Documentation | TimeZone |
timezone_abbreviations
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Selects a file of time zone abbreviations. |
| Data type | string |
| Default value | Default |
| Allowed values | Default |
| Parameter type | read-only |
| Documentation | timezone_abbreviations |
client_encoding
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the client-side encoding (character set). The default is to use the database encoding. |
| Data type | enumeration |
| Default value | UTF8 |
| Allowed values | BIG5,EUC_CN,EUC_JP,EUC_JIS_2004,EUC_KR,EUC_TW,GB18030,GBK,ISO_8859_5,ISO_8859_6,ISO_8859_7,ISO_8859_8,JOHAB,KOI8R,KOI8U,LATIN1,LATIN2,LATIN3,LATIN4,LATIN5,LATIN6,LATIN7,LATIN8,LATIN9,LATIN10,MULE_INTERNAL,SJIS,SHIFT_JIS_2004,SQL_ASCII,UHC,UTF8,WIN866,WIN874,WIN1250,WIN1251,WIN1252,WIN1253,WIN1254,WIN1255,WIN1256,WIN1257,WIN1258 |
| Parameter type | dynamic |
| Documentation | client_encoding |
DateStyle
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the display format for date and time values. |
| Data type | string |
| Default value | ISO, MDY |
| Allowed values | (ISO|POSTGRES|SQL|GERMAN)(, (DMY|MDY|YMD))? |
| Parameter type | dynamic |
| Documentation | DateStyle |
default_text_search_config
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Selects the text search configuration that is used by those variants of the text search functions that do not have an explicit argument specifying it. |
| Data type | string |
| Default value | pg_catalog.english |
| Allowed values | [A-Za-z._]+ |
| Parameter type | dynamic |
| Documentation | default_text_search_config |
extra_float_digits
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the number of digits displayed for floating-point values. |
| Data type | integer |
| Default value | 1 |
| Allowed values | -15-3 |
| Parameter type | dynamic |
| Documentation | extra_float_digits |
IntervalStyle
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the display format for interval values. |
| Data type | enumeration |
| Default value | postgres |
| Allowed values | postgres,postgres_verbose,sql_standard,iso_8601 |
| Parameter type | dynamic |
| Documentation | IntervalStyle |
lc_messages
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the language in which messages are displayed. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_messages |
lc_monetary
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting monetary amounts. |
| Data type | string |
| Default value | en_US.utf-8 |
| Allowed values | [A-Za-z0-9._ -]+ |
| Parameter type | dynamic |
| Documentation | lc_monetary |
lc_numeric
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting numbers. |
| Data type | string |
| Default value | en_US.utf-8 |
| Allowed values | [A-Za-z0-9._ -]+ |
| Parameter type | dynamic |
| Documentation | lc_numeric |
lc_time
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting date and time values. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_time |
TimeZone
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the time zone for displaying and interpreting time stamps. |
| Data type | string |
| Default value | UTC |
| Allowed values | [A-Za-z0-9/+_-]+ |
| Parameter type | dynamic |
| Documentation | TimeZone |
timezone_abbreviations
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Selects a file of time zone abbreviations. |
| Data type | string |
| Default value | Default |
| Allowed values | Default |
| Parameter type | read-only |
| Documentation | timezone_abbreviations |
client_encoding
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the client-side encoding (character set). The default is to use the database encoding. |
| Data type | enumeration |
| Default value | UTF8 |
| Allowed values | BIG5,EUC_CN,EUC_JP,EUC_JIS_2004,EUC_KR,EUC_TW,GB18030,GBK,ISO_8859_5,ISO_8859_6,ISO_8859_7,ISO_8859_8,JOHAB,KOI8R,KOI8U,LATIN1,LATIN2,LATIN3,LATIN4,LATIN5,LATIN6,LATIN7,LATIN8,LATIN9,LATIN10,MULE_INTERNAL,SJIS,SHIFT_JIS_2004,SQL_ASCII,UHC,UTF8,WIN866,WIN874,WIN1250,WIN1251,WIN1252,WIN1253,WIN1254,WIN1255,WIN1256,WIN1257,WIN1258 |
| Parameter type | dynamic |
| Documentation | client_encoding |
DateStyle
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the display format for date and time values. |
| Data type | string |
| Default value | ISO, MDY |
| Allowed values | (ISO|POSTGRES|SQL|GERMAN)(, (DMY|MDY|YMD))? |
| Parameter type | dynamic |
| Documentation | DateStyle |
default_text_search_config
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Selects the text search configuration that is used by those variants of the text search functions that do not have an explicit argument specifying it. |
| Data type | string |
| Default value | pg_catalog.english |
| Allowed values | [A-Za-z._]+ |
| Parameter type | dynamic |
| Documentation | default_text_search_config |
extra_float_digits
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the number of digits displayed for floating-point values. |
| Data type | integer |
| Default value | 1 |
| Allowed values | -15-3 |
| Parameter type | dynamic |
| Documentation | extra_float_digits |
IntervalStyle
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the display format for interval values. |
| Data type | enumeration |
| Default value | postgres |
| Allowed values | postgres,postgres_verbose,sql_standard,iso_8601 |
| Parameter type | dynamic |
| Documentation | IntervalStyle |
lc_messages
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the language in which messages are displayed. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_messages |
lc_monetary
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting monetary amounts. |
| Data type | string |
| Default value | en_US.utf-8 |
| Allowed values | [A-Za-z0-9._ -]+ |
| Parameter type | dynamic |
| Documentation | lc_monetary |
lc_numeric
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting numbers. |
| Data type | string |
| Default value | en_US.utf-8 |
| Allowed values | [A-Za-z0-9._ -]+ |
| Parameter type | dynamic |
| Documentation | lc_numeric |
lc_time
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting date and time values. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_time |
TimeZone
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the time zone for displaying and interpreting time stamps. |
| Data type | string |
| Default value | UTC |
| Allowed values | [A-Za-z0-9/+_-]+ |
| Parameter type | dynamic |
| Documentation | TimeZone |
timezone_abbreviations
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Selects a file of time zone abbreviations. |
| Data type | string |
| Default value | Default |
| Allowed values | Default |
| Parameter type | read-only |
| Documentation | timezone_abbreviations |
client_encoding
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the client-side encoding (character set). The default is to use the database encoding. |
| Data type | enumeration |
| Default value | UTF8 |
| Allowed values | BIG5,EUC_CN,EUC_JP,EUC_JIS_2004,EUC_KR,EUC_TW,GB18030,GBK,ISO_8859_5,ISO_8859_6,ISO_8859_7,ISO_8859_8,JOHAB,KOI8R,KOI8U,LATIN1,LATIN2,LATIN3,LATIN4,LATIN5,LATIN6,LATIN7,LATIN8,LATIN9,LATIN10,MULE_INTERNAL,SJIS,SHIFT_JIS_2004,SQL_ASCII,UHC,UTF8,WIN866,WIN874,WIN1250,WIN1251,WIN1252,WIN1253,WIN1254,WIN1255,WIN1256,WIN1257,WIN1258 |
| Parameter type | dynamic |
| Documentation | client_encoding |
DateStyle
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the display format for date and time values. |
| Data type | string |
| Default value | ISO, MDY |
| Allowed values | (ISO|POSTGRES|SQL|GERMAN)(, (DMY|MDY|YMD))? |
| Parameter type | dynamic |
| Documentation | DateStyle |
default_text_search_config
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Selects the text search configuration that is used by those variants of the text search functions that do not have an explicit argument specifying it. |
| Data type | string |
| Default value | pg_catalog.english |
| Allowed values | [A-Za-z._]+ |
| Parameter type | dynamic |
| Documentation | default_text_search_config |
extra_float_digits
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the number of digits displayed for floating-point values. |
| Data type | integer |
| Default value | 0 |
| Allowed values | -15-3 |
| Parameter type | dynamic |
| Documentation | extra_float_digits |
IntervalStyle
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the display format for interval values. |
| Data type | enumeration |
| Default value | postgres |
| Allowed values | postgres,postgres_verbose,sql_standard,iso_8601 |
| Parameter type | dynamic |
| Documentation | IntervalStyle |
lc_messages
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the language in which messages are displayed. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_messages |
lc_monetary
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting monetary amounts. |
| Data type | string |
| Default value | en_US.utf-8 |
| Allowed values | [A-Za-z0-9._ -]+ |
| Parameter type | dynamic |
| Documentation | lc_monetary |
lc_numeric
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting numbers. |
| Data type | string |
| Default value | en_US.utf-8 |
| Allowed values | [A-Za-z0-9._ -]+ |
| Parameter type | dynamic |
| Documentation | lc_numeric |
lc_time
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the locale for formatting date and time values. |
| Data type | string |
| Default value | en_US.utf8 |
| Allowed values | en_US.utf8 |
| Parameter type | read-only |
| Documentation | lc_time |
TimeZone
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Sets the time zone for displaying and interpreting time stamps. |
| Data type | string |
| Default value | UTC |
| Allowed values | [A-Za-z0-9/+_-]+ |
| Parameter type | dynamic |
| Documentation | TimeZone |
timezone_abbreviations
| Attribute | Value |
|---|---|
| Category | Client Connection Defaults / Locale and Formatting |
| Description | Selects a file of time zone abbreviations. |
| Data type | string |
| Default value | Default |
| Allowed values | Default |
| Parameter type | read-only |
| Documentation | timezone_abbreviations |