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.g.johnston@xxxxxxxxx> wrote: > > On Wed, Dec 21, 2022 at 9:25 PM Dhirendra Singh <dhirendraks@xxxxxxxxx> 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
