PostgreSQL 常用命令

创建用户

CREATE USER tom WITH PASSWORD 'myPassword';

授权用户创建数据库权限

ALTER USER username CREATEDB;

创建数据库

CREATE DATABASE jerry;

为用户指派数据库管理权限

GRANT ALL ON DATABASE jerry to tom;

Docker 访问

~ $ sudo docker run -it --rm --link postgres:postgres arm32v7/postgres psql -h postgres -U postgres
Password for user postgres: 
psql (10.3 (Debian 10.3-1.pgdg90+1))
Type "help" for help.

postgres=#