Thread: 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.