create user xiaoming with password ‘8RUy‘;
grant all on DATABASE yqxe to xiaoming;
\c mydb (切换到我的数据库yqxe)
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO xiaoming;
参考链接：https://blog.csdn.net/fwhezfwhez/article/details/88854470
postgres连接报错 permission denied for relation
原文：https://www.cnblogs.com/dengmeinan/p/13640247.html