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