AI Rumman wrote: > I have an application which query on the pg_shadow view. But the user that I was provided by my > hosting server does have permission to do that. > I checked that only superuser can query in pg_shadow view. But hosting service provider will not give > me superuser permission. > Is there any other alternative way that I may follow? You'll have to use pg_user or pg_roles. They won't show you the passwords though. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general