pg_encoding_to_char()

Overview

The pg_encoding_to_char() is a system catalog information function that converts an encoding internal identifier to a human-readable name.

Syntax

The syntax for the pg_encoding_to_char() function is as follows:

pg_encoding_to_char(number)

Parameters

The following parameters are required to execute function:

• number: specifies the integer value representing the encoding identifier

Examples

SELECT pg_encoding_to_char(1);

 pg_encoding_to_char
---------------------
 EUC_JP
(1 row)

SELECT pg_encoding_to_char(0);

 pg_encoding_to_char
---------------------
 SQL_ASCII
(1 row)

SELECT pg_encoding_to_char(-1);

 pg_encoding_to_char
---------------------

(1 row)