Regular expression for lower case to upper case.

Eagna <eagna@protonmail.com>

From: Eagna <eagna@protonmail.com>
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2022-12-10T09:40:22Z
Lists: pgsql-general
Hi all,

I want a regex to change the case of a field from UPPER to lower.

I know about the UPPER() and LOWER() functions and they are not what I want.

I would have thought this should be very simple, but I've searched a lot and can't seem to get an answer.

Here's a fiddle with a couple of things that I've tried - I'm obviously missing something that should be starting me in the face.

Any input appreciated.

E.