> > Are you talking about the sort order? Then there's no problem with
> > encoding itself.
>
> The tables in template1 in encoding E1 are compied into the new database
> in encoding E2. Not all encodings are compatable, so you can't even
> convert from E1 to E2.
In this case you just set your terminal encoding to E1, then SELECT
the table. Point is you do not use set client_encoding or \encoding
command. This will work as long as both E1 and E2 are single byte
encodings.
--
Tatsuo Ishii