Override the Default Locale for a Session

To override the default locale for a specific session, use one of the following commands:

You can also use the Specifying Locale: Short Form of a locale in either of these commands:

=> SET LOCALE TO LEN;
INFO 2567:  Canonical locale: 'en'
Standard collation: 'LEN'
English
=> \locale LEN
INFO 2567:  Canonical locale: 'en'
Standard collation: 'LEN'
English

You can use these commands to override the locale as many times as needed during a database session. The session locale setting applies to any subsequent commands issued in the session.

See Also