[SOLVED] Postgres 14 Backslash Z is not giving the correct output

Issue

This Content is from Stack Overflow. Question asked by Murthy Karra

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 | | |

I don’t see any roles (postgres or others that I made). In my MAC I get the expected results with postgres super-user having all the privileges on tables and my regular user none.
Can someone help? I re-installed postgres to the latest version and restarted it a bunch of times.
Thanks



Solution

That is normal and (surprisingly) means that the tables have the default privileges: the owner has all permissions and everybody else has no permissions. If you grant extra privileges, you will see something in the \dp output.


This Question was asked in StackOverflow by Murthy Karra and Answered by Laurenz Albe It is licensed under the terms of CC BY-SA 2.5. - CC BY-SA 3.0. - CC BY-SA 4.0.

people found this article helpful. What about you?