Hi,

I have added two built-in functions:
	pg_char_to_encoding()	-- convert encoding string to encoding id
	pg_encoding_to_char()	-- convert encoding id to encoding string

Main purpose for this is to allow psql -l to print encoding names
rather than encoding ids (sample output from psql shown below) in a
multibyte enabled installation.

        List of databases
  Database  |  Owner  | Encoding 
------------+---------+----------
 regression | t-ishii | EUC_JP
 template1  | t-ishii | EUC_JP
 test       | t-ishii | EUC_JP
(3 rows)

This is much more "user friendly" IMHO.

initdb required.
--
Tatsuo Ishii

Tue, 18 Jan 2000 14:51:14 +0900
Tatsuo Ishii <t-ishii@sra.co.jp>
pg_proc.h changed
I've been wondering about that. Great!

On 2000-01-18, Tatsuo Ishii mentioned:

> Hi,
> 
> I have added two built-in functions:
> 	pg_char_to_encoding()	-- convert encoding string to encoding id
> 	pg_encoding_to_char()	-- convert encoding id to encoding string
> 
> Main purpose for this is to allow psql -l to print encoding names
> rather than encoding ids (sample output from psql shown below) in a
> multibyte enabled installation.
> 
>         List of databases
>   Database  |  Owner  | Encoding 
> ------------+---------+----------
>  regression | t-ishii | EUC_JP
>  template1  | t-ishii | EUC_JP
>  test       | t-ishii | EUC_JP
> (3 rows)
> 
> This is much more "user friendly" IMHO.
> 
> initdb required.
> --
> Tatsuo Ishii
> 
> ************
> 
> 

-- 
Peter Eisentraut                  Sernanders vï¿½g 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden



Wed, 19 Jan 2000 03:58:37 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
Re: [HACKERS] pg_proc.h changed