Re: List of encodings - Mailing list pgsql-general

From Tom Lane
Subject Re: List of encodings
Date
Msg-id 3432386.1776524911@sss.pgh.pa.us
Whole thread
In response to List of encodings  (Igor Korot <ikorot01@gmail.com>)
List pgsql-general
Igor Korot <ikorot01@gmail.com> writes:
> Does the list shown in
> https://www.postgresql.org/docs/current/multibyte.html#MULTIBYTE-CHARSET-SUPPORTED
> stored somewhere in INFORMATION_SCHEMA?

No, the SQL standard doesn't specify any such view.

You could try

# select n, pg_encoding_to_char(n) from generate_series(0,50) n;
 n  | pg_encoding_to_char
----+---------------------
  0 | SQL_ASCII
  1 | EUC_JP
  2 | EUC_CN
  3 | EUC_KR
  4 | EUC_TW
  5 | EUC_JIS_2004
  6 | UTF8
  ...

            regards, tom lane



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: List of encodings
Next
From: Karsten Hilbert
Date:
Subject: unique constraint violation on multiple-rows update