PostgreSQL常用操作
- 创建数据库：
CREATE DATABASE db_name template tpl_name; - 删除数据库：
drop database xxx; - 创建用户：
CREATE USER xxx WITH PASSWORD 'admin'; - 删除用户：
drop user username; - 授权：
GRANT ALL PRIVILEGES ON DATABASE my_database TO my_user;
CREATE DATABASE db_name template tpl_name;drop database xxx;CREATE USER xxx WITH PASSWORD 'admin';drop user username;GRANT ALL PRIVILEGES ON DATABASE my_database TO my_user;