Set COLLATE on a session level

From: Dirk Mika <Dirk(dot)Mika(at)mikatiming(dot)de>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Set COLLATE on a session level
Date: 2020-11-20 07:13:42
Message-ID: 0DDE56FB-89A8-4621-BF5E-8CE3461F4983@mikatiming.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

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.

Regards
Dirk

--
Dirk Mika
Software Developer

mika:timing GmbH
Strundepark - Kürtener Str. 11b
51465 Bergisch Gladbach
Germany

fon +49 2202 2401-1197
dirk(dot)mika(at)mikatiming(dot)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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Srinivasa T N 2020-11-20 07:45:14 Meaning of below statement
Previous Message Tom Lane 2020-11-20 06:29:17 Re: Locking and postgres_fdw extension