我正在try 重置密码.
r9mzsy20=# ALTER USER 9mz_dba WITH PASSWORD '92837474';
ERROR: syntax error at or near "9"
LINE 1: ALTER USER 9mz_dba WITH PASSWORD '92837474..
对于用户u_9mz_rw和u_9mz_ro，我能够重置密码.
ALTER USER u_9mz_ro PASSWORD '92837474' VALID UNTIL 'infinity';
ALTER USER u_9mz_rw PASSWORD '92837474' VALID UNTIL 'infinity';
但对于这个用户9mz_dba，我遇到了一个错误.
有人能帮忙吗？
这是我的用户列表:
try 在用户名周围添加双引号":
ALTER USER "9mz_dba" WITH PASSWORD '92837474';
从4.1.1. Identifiers and Key Words:
SQL identifiers and key words must begin with a letter (
a-z, but also letters with diacritical marks and non-Latin letters) or an underscore (_)
...
Quoted identifiers can contain any character, except the character with code zero.
这意味着用户/角色标识符以doesn't以a-z开头或下划线_是完全可以的，但要引用它，您需要将其包裹在双引号中.
此外，您丢失了带有插入符号^字符的错误消息的第3行，这应该澄清它指向的是前9字符，而不是第二个字符:demo
ERROR: syntax error at or near "9"
LINE 2: ALTER USER 9mz_dba WITH PASSWORD '92837474';
^
在PostgreSQL 15和16中，数字文字处理已更改，这意味着错误消息也将更改，try 将其解释为数字但失败:demo
ERROR: trailing junk after numeric literal at or near "9m"
LINE 2: ALTER USER 9mz_dba WITH PASSWORD '92837474';
^