Re: Facing issue with cert authentication

On Thu, 2022-12-22 at 14:39 +0530, Dhirendra Singh wrote:
> On Thu, Dec 22, 2022 at 10:21 AM David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> > On Wed, Dec 21, 2022 at 9:25 PM Dhirendra Singh <dhirendraks(at)gmail(dot)com> wrote:
> > >
> > > I am using cert authentication to authenticate.
> > > I have created a user with name S114546 (with uppercase 'S'). user
> > > created is s114546 (with lowercase 's').
> > >
> > > I can create the user with uppercase 'S' by double quoting the username.
> > > but the script which creates the user will do the same for all users
> > > which i do not want.
> >
> > It seems considerably easier to modify your database role creation
> > compared to the PKI certification creation.  I suggest you figure out
> > what you can live with on that front.
>
> It seems regex provides a way to convert the extracted string to lowercase
> by using "\L\1". but this is also not working...seems not supported by postgres.
> Is there a way to convert the matched string to lowercase ?

That syntax is not supported by PostgreSQL, and I cannot think of a better
way that to create the role with an upper case "S".

Yours,
Laurenz Albe