How support more native locale in one cluster?

[Michal Seidl <michal.seidl@xxxxxxxxx>]

Hi, I can not figure out how to solve the problem with LOCALE. Example: 
- 3 tables, each of them with a text or varchar column.
- The first table with text in German
- The second table with text in Czech
- the third one with text in English

How to force Postgre to use correct locale for ORDER BY, LIKE etc 
according to language used in table?

Thanks Michal