Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1r2t6j-001FPh-Q5
	for pgsql-admin@arkaria.postgresql.org; Tue, 14 Nov 2023 13:05:34 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1r2t6i-007U5f-6e
	for pgsql-admin@arkaria.postgresql.org; Tue, 14 Nov 2023 13:05:32 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <paul@pscs.co.uk>)
	id 1r2t6h-007U5X-Ke
	for pgsql-admin@lists.postgresql.org; Tue, 14 Nov 2023 13:05:31 +0000
Received: from mail2.pscs.co.uk ([178.159.10.131] helo=mail.pscs.co.uk)
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <paul@pscs.co.uk>)
	id 1r2t6e-006OIo-QH
	for pgsql-admin@lists.postgresql.org; Tue, 14 Nov 2023 13:05:30 +0000
Authentication-Results: mail.pscs.co.uk; spf=none; auth=pass
 (cram-md5) smtp.auth=pscs
Received: from lmail.pscs.co.uk ([192.168.120.1]) by mail.pscs.co.uk
 ([192.168.120.185] running VPOP3) with ESMTPSA (TLSv1.3
 TLS_AES_256_GCM_SHA384) for <pgsql-admin@lists.postgresql.org>; Tue,
 14 Nov 2023 13:05:25 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pscs.co.uk;
 q=dns/txt; s=lmail;
 h=Message-ID:Date:MIME-Version:Subject:To:References:From:In-Reply-To
 :Content-Type:Content-Transfer-Encoding:Cc:Reply-to:Sender;
 t=1699967115; x=1700571915;
 bh=DkHNbRSNNHG6qOVIoSLiDGW1wnh3QdkGUOer1RsLZ4w=;
 b=oBj+g2gQLLCMyrPK4VaFMHxTtulA3XIH0aVkGnMpUyICydT+jjwbxPVHwDKJ3/287o0sOJgs
 p3aNYwlHEMgrhih1pRZHxubS2apsuKVj/G3JYTwAJOPmz0rLtBgyHQaqYt2msvKt6ffvQS5zAB
 kkuNT+MrRM5p9//rWEMdnLrtc=
Authentication-Results: lmail.pscs.co.uk; spf=none; auth=pass
 (cram-md5) smtp.auth=paul
Received: from [192.168.57.78] ([82.68.48.206]
 (82-68-48-206.dsl.in-addr.zen.co.uk)) by lmail.pscs.co.uk
 ([192.168.120.70] running VPOP3) with ESMTPSA (TLSv1.3
 TLS_AES_256_GCM_SHA384) for <pgsql-admin@lists.postgresql.org>; Tue,
 14 Nov 2023 13:05:15 -0000
Message-ID: <79d4ec67-40b2-427f-aa40-2588bacb4556@pscs.co.uk>
Date: Tue, 14 Nov 2023 13:05:15 +0000
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Update "usename" in pg_user
Content-Language: en-GB
To: pgsql-admin@lists.postgresql.org
References: 
 <PR3PR04MB73409EB3F2695DA61418F784D6B2A@PR3PR04MB7340.eurprd04.prod.outlook.com>
From: Paul Smith* <paul@pscs.co.uk>
In-Reply-To: 
 <PR3PR04MB73409EB3F2695DA61418F784D6B2A@PR3PR04MB7340.eurprd04.prod.outlook.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Authenticated-Sender: paul
X-Server: VPOP3 Enterprise V8.5 - Registered
X-Organisation: Paul Smith Computer Services
X-VPOP3Tester: 12 345
X-Authenticated-Sender: pscs
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/79d4ec67-40b2-427f-aa40-2588bacb4556%40pscs.co.uk>
Precedence: bulk

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