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