进入postgresql用户:
sudo su - postgres
删除数据库账户
dropuser username -e;
查看所有数据库账户
\du \du+
创建账户:
sudo -u postgres createuser --pwprompt zblog sudo -u postgres createdb -O zblog zblog
进入数据库:
psql
数据库下的操作:
提升权限
GRANT ALL ON schema public TO username; GRANT USAGE ON schema public TO username;
撤销权限
REVOKE ALL ON schema public FROM username; REVOKE USAGE ON schema public TO username;