Re: List of encodings

On Monday, April 20, 2026, Igor Korot <ikorot01(at)gmail(dot)com> wrote:

> Hi, everybody,
>
> On Mon, Apr 20, 2026 at 8:29 PM David G. Johnston
> <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> >
> > On Mon, Apr 20, 2026 at 7:47 PM Igor Korot <ikorot01(at)gmail(dot)com> wrote:
> >>
> >> My understanding is that if I have 3 "BIG5" encodings, only one can be
> >> 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 “no, it’s not (i.e., it’s hardcoded inside), but
you can get to it indirectly”. In this case if you involve the
pgconversion table you should ignore the conversion is default field as it
has nothing to do with the question - what encodings does the system
recognize. You also got an answer involving generate_series.

David J.