Postgres Pro
Downloads
Home   >   mailing lists

Set COLLATE on a session level - Mailing list pgsql-general

From Dirk Mika
Subject Set COLLATE on a session level
Date
Msg-id 0DDE56FB-89A8-4621-BF5E-8CE3461F4983@mikatiming.de
Whole thread Raw
Responses Re: Set COLLATE on a session level
Re: Set COLLATE on a session level
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Locking and postgres_fdw extension
Next
From: Srinivasa T N
Date:
Subject: Meaning of below statement