On Wed, Jun 29, 2005 at 08:57:32 -0600,
"Walker, Jed S" <Jed_Walker@cable.comcast.com> wrote:
> How can I query the database to determine if a user has usage on a
> particular schema, and how can I query the database to find out all the
> schemas a user has usage on?
The has_schema_privilege function will allow you to check if a user
has access to a schema. You can use pg_users to get a list of all
users and pg_namespace can be used to get a list of all schemas.