postgres连接报错 permission denied for relation

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

原文：https://www.cnblogs.com/dengmeinan/p/13640247.html