When I query my database using a role in pgAdmin on a remote client, I get the results of the query. However if I run the same query directly on the db server with the same role , I don't see the query output. I see the table are present with the "\dt" command but I am not able to view the results of the queries on these tables. Is there some configuration that is needed to enable querying the db from the same host ?
Note: Made edits to the question based on the comments.