I am new to Postgres coming from a background in SQL Server, Informix, MySQL and Oracle. However, I am a little confused right now and maybe someone can answer this.
Typically a super user such as SA, mysql, Informix etc … has rights to all objects in any database. However, we have a database owned by a user (otheruser) and if I log in as superuser postgres and connect to the database in question I cannot see any objects. What am I missing here?
I am logging in then issuing \c dbname
Here are the entries for roles
List of roles
Role name | Superuser | Create role | Create DB | Connections | Member of
------------+-----------+-------------+-----------+-------------+------------
postgres | yes | yes | yes | no limit | {}
otheruser | no | no | no | no limit | {siteadmins}
siteadmins | no | no | no | no limit | {}
Thanks for any feedback.
JT
This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system.