CREATE DATABASE testdb TEMPLATE template0 ENCODING UTF8 LC_COLLATE 'zh_CN.UTF-8' LC_CTYPE 'zh_CN.UTF-8'; # 创建数据库

create role test login password '123456' valid until 'infinity'; # 创建不过期用户

grant all privileges on database testdb to test ; # 为用户创建数据库权限

drop role test;//删除用户