Обсуждение: Name of encodings: in which system catalog?

When I SELECT encoding FROM pg_database, I get a number. When I type \l,
encodings are displayed as a human-readable string. I do not find where these
strings are stored. I've read "PostgreSQL 7.2.1 Developer's Guide", Chapter 3.
"System Catalogs" but without result.

PS: this is because I wonder why I can enter composed characters like ç or é
when the database is in SQL_ASCII but not when it is UNICODE.

try psql -E and retype \l


Stephane Bortzmeyer wrote:
> When I SELECT encoding FROM pg_database, I get a number. When I type \l,
> encodings are displayed as a human-readable string. I do not find where these
> strings are stored. I've read "PostgreSQL 7.2.1 Developer's Guide", Chapter 3.
> "System Catalogs" but without result.
>
> PS: this is because I wonder why I can enter composed characters like ç or é
> when the database is in SQL_ASCII but not when it is UNICODE.

On Wed, Jul 03, 2002 at 10:16:38AM +0200,
 frbn <frbn@efbs-seafrigo.fr> wrote
 a message of 19 lines which said:

> try psql -E and retype \l

Oh, yes, I always forgot this very useful trick. Thanks. For thoses
interested, encodings are not stored in a table but in a function.