El Tue, 8 Sep 2026 21:22:43 +0000 (UTC)
RVP <[email protected]> escribió:
>
> This works if you use LC_CTYPE instead: `export LC_CTYPE=C.UTF-8'
Thank you!! Indeed, setting only LC_CTYPE does the trick, and everything
becomes much easier, starting with the documentation :)
psql -U pgsql -l
List of databases
Name | Owner | Encoding | Locale Provider | Collate | Ctype | Locale |
ICU Rules | Access privileges
-----------+-------+----------+-----------------+---------+---------+--------+-----------+-------------------
postgres | pgsql | UTF8 | libc | C | C.UTF-8 | |
|
template0 | pgsql | UTF8 | libc | C | C.UTF-8 | |
| =c/pgsql +
| | | | | | |
| pgsql=CTc/pgsql
template1 | pgsql | UTF8 | libc | C | C.UTF-8 | |
| =c/pgsql +
| | | | | | |
| pgsql=CTc/pgsql
(3 rows)
Best
Luis
