SELECT datname, pg_encoding_to_char(encoding) FROM pg_database;
…lists all the databases, each with its encoding type.
However, I am trying to find out what are all the encoding types available in the PostgreSQL server. Can I query for all available encoding types?
Or are the only encoding types ever available listed in Chapter 23.3 Character Set Support?