MIME-Version: 1.0
References: <CA+FnnTxFMiA+KMfypfGyY43G2kSx6-t5A351snUMmWC-2Lxvaw@mail.gmail.com>
 <CAKFQuwZOH6BPtaWJKr9jRGxdJt05YtLAZn1s_fYt=uzAASm9CQ@mail.gmail.com>
 <CA+FnnTymNs9_3pBci01_Uu5OTNJFngOhu8_khpmUs88V8kX86Q@mail.gmail.com>
 <71cd4015-9002-4173-bd9a-075f7afb3c20@aklaver.com> <CA+FnnTzx90AzTu07zVGMCYmvBYs_VsL9k2E7eBkzg_rTRwZbeA@mail.gmail.com>
 <5f263a8a-9c30-4118-b410-6e25eafde156@aklaver.com> <CA+FnnTxJyrnxR0hhV8T8J7Gb=MZ=OrtrEUcyoMf14-WHKgSb-A@mail.gmail.com>
 <CANzqJaBRRq5T-3VJc5fzGSOotAW8eXg1cvh0XwoRc4akO+mamg@mail.gmail.com>
 <CA+FnnTy2D85znPLd-G47Uyt4RTF289g45XnSXrLQEHG8CeN2qg@mail.gmail.com>
 <CA+FnnTx_RXR_3CY6TbO8ov+Ky+VoiDEopmBisPMA9+cWoZqAMw@mail.gmail.com>
 <CAKFQuwacHL53WNxg_wcL1Zqs=pVMZPtq4yufUBLTSNJ+aAX-JA@mail.gmail.com>
 <CA+FnnTzuO6qXVt-_UN_y5odFEZPD8a6sZh37TELmaoqKnvxTVQ@mail.gmail.com> <CAKFQuwZcTd9ixAZa1Uei5k8gwUrnCqZsb6JrGccxMGMCGNURMQ@mail.gmail.com>
In-Reply-To: <CAKFQuwZcTd9ixAZa1Uei5k8gwUrnCqZsb6JrGccxMGMCGNURMQ@mail.gmail.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Mon, 20 Apr 2026 21:58:24 -0700
Message-ID: <CA+FnnTxpJox2Zn_69qLTwEUM0-ypSkYCa+diSRsorkK=6c22Ew@mail.gmail.com>
Subject: Re: List of encodings
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Ron Johnson <ronljohnsonjr@gmail.com>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTxpJox2Zn_69qLTwEUM0-ypSkYCa%2BdiSRsorkK%3D6c22Ew%40mail.gmail.com>
Precedence: bulk

David,

On Mon, Apr 20, 2026 at 9:32=E2=80=AFPM David G. Johnston
<david.g.johnston@gmail.com> wrote:
>
> On Monday, April 20, 2026, Igor Korot <ikorot01@gmail.com> wrote:
>>
>> Hi, everybody,
>>
>> On Mon, Apr 20, 2026 at 8:29=E2=80=AFPM David G. Johnston
>> <david.g.johnston@gmail.com> wrote:
>> >
>> > On Mon, Apr 20, 2026 at 7:47=E2=80=AFPM Igor Korot <ikorot01@gmail.com=
> wrote:
>> >>
>> >> My understanding is that if I have 3 "BIG5" encodings, only one can b=
e
>> >> a default.
>> >
>> >
>> > That would be a misunderstanding of what a conversion table is about.
>>
>> What I did:
>>
>> 1. Google "PostgreSQL create database"
>> 2. Click the first link - to PostgreSQL documentation.
>> 3. The command have many options. One of them is "Encoding".
>> 4, Scrolled down for an explanation. The explanation had a link.
>> 5. Clicked the link. Received a page with the list of encodings.
>>
>> At this point I asked the original question
>> Does the list on that page stored somewhere? Or it is hardcoded inside
>> the sources?
>>
>> That's when I started receiving a references to that table.
>>
>> Did I ask the wrong question?
>
>
> And the answer you got was =E2=80=9Cno, it=E2=80=99s not (i.e., it=E2=80=
=99s hardcoded inside), but you can get to it indirectly=E2=80=9D.  In this=
 case if you involve the pgconversion table you should ignore the conversio=
n is default field as it has nothing to do with the question - what encodin=
gs does the system recognize.  You also got an answer involving generate_se=
ries.

Understood, thx. This clears it up.

Sorry for the confusion.

And yes - I will query the pg_conversion table.

Thx once again.

>
> David J.
>