//创建programer用户
CREATE USER programer WITH PASSWORD 'your password'
//将test_db的权限授权给programer
GRANT ALL PRIVILEGES ON DATABASE test_db  TO programer;
//选择你要授权的数据库
\c test_db
//在这个数据下将表授权给programer
GRANT ALL PRIVILEGES ON all tables in schema public  TO programer;