Re: List of encodings

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Igor Korot <ikorot01(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: List of encodings
Date: 2026-04-18 15:08:31
Message-ID: 3432386.1776524911@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Igor Korot <ikorot01(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2026-04-19 13:17:07 unique constraint violation on multiple-rows update
Previous Message David G. Johnston 2026-04-18 07:19:21 Re: List of encodings