On Wed, Jun 03, 2009 at 01:46:00PM -0500, Louis Lam wrote:
> So if I need to find out what table, view and function are granted to
> user or role. I should be force to use pg_class and pg_proc? Unless I
> can have superuser access?
Use \dv+ on the information_schema view you want and copy the query.
Take out the permission check and you're done.
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.