使用 postges 用户登录

$ docker exec -it ${容器ID} psql -U postgres

创建用户

CREATE USER test WITH PASSWORD '123456';

创建数据库

CREATE DATABASE test OWNER test;

授权

GRANT ALL PRIVILEGES ON DATABASE test TO test;
GRANT ALL ON DATABASE test TO test;

切换数据库

postgres=# \c test
You are now connected to database "test" as user "postgres".

安装扩展

CREATE EXTENSION pgcrypto;

切换用户

test=# \c - test
You are now connected to database "test" as user "test".