频道栏目
首页 > 资讯 > 其他综合 > 正文

postgres更改数据库用户密码的方法

17-09-21        来源:[db:作者]  
收藏   我要投稿

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

相关TAG标签
上一篇:pg查看每个数据库对应的目录的方法
下一篇:python继承_python编程开发如何实现继承
相关文章
图文推荐

关于我们 | 联系我们 | 广告服务 | 投资合作 | 版权申明 | 在线帮助 | 网站地图 | 作品发布 | Vip技术培训 | 举报中心

版权所有: 红黑联盟--致力于做实用的IT技术学习网站