On Fri, 2020-11-20 at 07:13 +0000, Dirk Mika wrote: > we come from the Oracle world and we have an application that, depending on a setting, > sends the command ALTER SESSION SET NLS_SORT=... when connecting to the database. > > Is there a similar way to set a COLLATE for a session in PostgreSQL? > > I know that I can specify a COLLATE for a SELECT statement in the ORDER BY Clause, > but then I would have to adjust the statements in the client and statements that are > automatically generated by the database components used, would not be affected. There is no way to do that in PostgreSQL. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
