Thread: pg_proc.h changed

Hi,

I have added two built-in functions:pg_char_to_encoding()    -- convert encoding string to encoding
idpg_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_JPtemplate1  | t-ishii | EUC_JPtest       | t-ishii |
EUC_JP
(3 rows)

This is much more "user friendly" IMHO.

initdb required.
--
Tatsuo Ishii

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