"Rodrigo Hjort" <rodrigo.hjort@gmail.com> writes:
> The fact is that I can't raise PostgreSQL with C encoding, as special
> characters are used on most tables.
You're confusing locale and encoding, which are two different (though
interrelated) things.
I suspect the right choice for you will be to use C locale with UTF8
encoding, or possibly one of the LATINn encodings.
regards, tom lane