Re: Update "usename" in pg_user

On 14/11/2023 12:56, Bernd Lentes wrote:
> Due to change of the LDAP server I need to modify the username now.
>  From firstname.lastname to firstname.lastname@helmholtz-munich.de.
> I tried the following (just for one user to test it):
>
> update pg_user set usename = 'usename@helmholtz-munich.de' where usename = 'dorota.germann';

1) don't update system tables directly unless you absolutely must

ALTER USER <username> RENAME TO <new_username> is what you want

2) To use characters other than alphanumeric or _ then you need to use 
double quotes


So:

ALTER USER dorota.germann RENAME TO "dorota.germann@helmholtz-munich.de";

should do the job

Paul