I am logged into the Postgres14 Windows server using psql and as the postgres super-user. However, when I type in \z or \dp I don't get the same output as I do in my MAC. I get the following
training=# \dp+
Access privileges
Schema | Name | Type | Access privileges | Column privileges | Policies |
---|---|---|---|---|---|
public | accounts | table | |||
public | address | table |
我没有看到任何角色(波斯格雷斯或其他我制作的角色).在我的MAC中,我得到了预期的结果,postgres超级用户拥有表的所有权限,而我的普通用户没有. 有人能帮帮忙吗?我将postgres重新安装到最新版本,并多次重启. 谢谢