On Tue, May 17, 2022 at 6:21 AM Chirag Karkera <chiragkrkr...@gmail.com> wrote:
> Thanks David for your reply! > > But when i created a role i am not able to view objects under > information_schema.* > > I mean I am not able to view the data, I can see only the column names. > >> >> Which goes to demonstrate you have permissions. But information_schema uses the permissions of the executing user to decide what to show - it is pre-filtered (and doesn't address PostgreSQL-only features). If you need less restrictive behavior your best bet is to just use the system catalogs. Those give you everything. David J.
