Hello,
we come from the Oracle world and we have an application that, depending on a setting, sends the command ALTER SESSION
SETNLS_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
statementsin the client and statements that are automatically generated by the database components used, would not be
affected.
Regards
Dirk
--
Dirk Mika
Software Developer
mika:timing GmbH
Strundepark - Kürtener Str. 11b
51465 Bergisch Gladbach
Germany
fon +49 2202 2401-1197
dirk.mika@mikatiming.de
www.mikatiming.de
AG Köln HRB 47509 * WEEE-Reg.-Nr. DE 90029884
Geschäftsführer: Harald Mika, Jörg Mika
## INEOS 1:59 memories
## https://www.facebook.com/mikatiming