How to change date language to Russian in PostgreSQL?

Question

PostgreSQL

Hello! When outputting the date like this, I get the following output:

SELECT to_char(now(), 'dd.TMmon')
> 08.may

I can change the language of the month to Russian with a few queries:

SET lc_time = 'ru_RU';
SELECT to_char(now(), 'dd.TMmon')
> 08.мая

But how do I do it with a single request?

Answer 1

1. Is it easier to convert the date on the application side?
2. Change postgresql.conf in the config lc_time = 'ru_RU'
3. You already have everything with one request.