Updated on 2023-07-06 GMT+08:00

Predefined Parameters

This section describes the predefined parameters added to PostgreSQL Enhanced Edition on the basis of PostgreSQL 11 open source edition.

Table 1 Predefined parameters

Predefined Parameter

Description

NLS_DATE_FORMAT

Defines the date format.

NLS_DATE_LANGUAGE

Defines the date language.

NLS_DUAL_CURRENCY

Defines the local currency symbols for the currencies of specific territories or countries.

NLS_CURRENCY

Defines the currency symbol.

NLS_TIME_FORMAT

Defines the time format without the time zone.

NLS_TIME_TZ_FORMAT

Defines the time format without the time zone.

NLS_TIMESTAMP_FORMAT

Defines the timestamp format without the time zone.

NLS_TIMESTAMP_TZ_FORMAT

Defines the timestamp format with the time zone.

NLS_NUMERIC_CHARACTERS

Defines the characters used as group separator and decimal character.

NLS_ISO_CURRENCY

Defines the ISO currency symbols for the currencies of specific territories or countries.

NLS_TERRITORY

Resets the values of NLS_CURRENCY, NLS_ISO_CURRENCY, and NLS_NUMERIC_CHARACTERS based on the regional currency and displayed number format.

NLS_LANGUAGE

Defines the default language of the database.

NLS_LENGTH_SEMANTICS

Defines the default length semantics of character strings. The value is BYTE or CHAR.

NLS_SORT

Defines the collating sequence for local characters.

NLS_COMP

Defines the collation behavior of database sessions.