Re: Table name with umlauts

Thomas Kellerer <spam_eater@gmx.net> writes:
> I'm curious why the following is not working:

> postgres=# show client_encoding;
>   client_encoding
> -----------------
>   UTF8
> (1 row)


> postgres=# create table umlaut_test_� (id integer);
> ERROR:  invalid byte sequence for encoding "UTF8": 0xf6202869

It looks to me like your console is not in fact producing UTF8;
it's representing � as 0xf6, which I think is right for Latin1.
Select the proper client_encoding.

            regards, tom lane