public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: Igor Korot <[email protected]>
Cc: Ron Johnson <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: List of encodings
Date: Mon, 20 Apr 2026 21:32:06 -0700
Message-ID: <CAKFQuwZcTd9ixAZa1Uei5k8gwUrnCqZsb6JrGccxMGMCGNURMQ@mail.gmail.com> (raw)
In-Reply-To: <CA+FnnTzuO6qXVt-_UN_y5odFEZPD8a6sZh37TELmaoqKnvxTVQ@mail.gmail.com>
References: <CA+FnnTxFMiA+KMfypfGyY43G2kSx6-t5A351snUMmWC-2Lxvaw@mail.gmail.com>
<CAKFQuwZOH6BPtaWJKr9jRGxdJt05YtLAZn1s_fYt=uzAASm9CQ@mail.gmail.com>
<CA+FnnTymNs9_3pBci01_Uu5OTNJFngOhu8_khpmUs88V8kX86Q@mail.gmail.com>
<[email protected]>
<CA+FnnTzx90AzTu07zVGMCYmvBYs_VsL9k2E7eBkzg_rTRwZbeA@mail.gmail.com>
<[email protected]>
<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>
On Monday, April 20, 2026, Igor Korot <[email protected]> wrote:
> Hi, everybody,
>
> On Mon, Apr 20, 2026 at 8:29 PM David G. Johnston
> <[email protected]> wrote:
> >
> > On Mon, Apr 20, 2026 at 7:47 PM Igor Korot <[email protected]> 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.
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: List of encodings
In-Reply-To: <CAKFQuwZcTd9ixAZa1Uei5k8gwUrnCqZsb6JrGccxMGMCGNURMQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox