postgres更改数据库用户密码

最新推荐文章于 2024-09-01 00:14:14 发布

lk_db

最新推荐文章于 2024-09-01 00:14:14 发布

阅读量6.4k

点赞数

分类专栏： Highgo DB PostgreSQL

本文链接：https://blog.csdn.net/lk_db/article/details/78039271

版权

Highgo DB 同时被 2 个专栏收录

171 篇文章 2 订阅

订阅专栏

PostgreSQL

162 篇文章 2 订阅

订阅专栏

postgres=# alter user postgres9.6 with password highgo123;
ERROR: syntax error at or near ".6"
LINE 1: alter user postgres9.6 with password highgo123;
^
postgres=# alter user 'postgres9.6' with password highgo123;
ERROR: syntax error at or near "'postgres9.6'"
LINE 1: alter user 'postgres9.6' with password highgo123;
^
postgres=# alter user "postgres9.6" with password highgo123;
ERROR: syntax error at or near "highgo123"
LINE 1: alter user "postgres9.6" with password highgo123;
^

postgres=# alter user 'postgres9.6' with password 'highgo123';
ERROR: syntax error at or near "'postgres9.6'"
LINE 1: alter user 'postgres9.6' with password 'highgo123';

# alter user postgres9.6 with password 'highgo123';
ERROR: syntax error at or near ".6"
LINE 1: alter user postgres9.6 with password 'highgo123';
^
Time: 0.366 ms

postgres=# alter user "postgres9.6" with password 'highgo123';
ALTER ROLE