| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Dirk Mika <Dirk(dot)Mika(at)mikatiming(dot)de>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Set COLLATE on a session level |
| Date: | 2020-11-20 11:31:42 |
| Message-ID: | 9fd0eef06639e633e258461e5baad9734bcbc1ba.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dirk Mika | 2020-11-20 14:28:25 | Re: Set COLLATE on a session level |
| Previous Message | Raul Kaubi | 2020-11-20 11:00:45 | Re: Determine if postgresql cluster running is primary or not |