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;//删除用户