首先登录数据库
psql -U your_username -d your_database;
然后用alter role命令。注意,下面这句是错误的。会提示role “administrator” does not exist
ALTER ROLE Administrator PASSWORD 'A@2000';
下面这句才是正确的
ALTER ROLE "Administrator" PASSWORD 'A@2000';
首先登录数据库
psql -U your_username -d your_database;
然后用alter role命令。注意,下面这句是错误的。会提示role “administrator” does not exist
ALTER ROLE Administrator PASSWORD 'A@2000';
下面这句才是正确的
ALTER ROLE "Administrator" PASSWORD 'A@2000';