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 <klep...@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.
signature.asc
Description: Digital signature
