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:
Show quoted text
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.