Re: Suggestion: additional system views - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Suggestion: additional system views
Date
Msg-id 200410282007.43934.josh@agliodbs.com
Whole thread Raw
In response to Re: Suggestion: additional system views  (Neil Conway <neilc@samurai.com>)
Responses Re: Suggestion: additional system views
List pgsql-hackers
Neil,

> pg_functions might be useful, but what would pg_users offer that pg_user
> does not already do?

Show a list of groups that the user belongs to?  Same thing with pg_groups; 
showing the list of users in the group.

> A pg_sequences view might also be handy.

Yes.  Anything else?  So far I have:

pg_users
pg_groups
pg_functions
pg_sequences
hmmm ...
pg_schemas 
pg_tablespaces 
... as well, just for completeness.

This is obviously and 8.1 thing, so I'll put it on my task list for after 8.0 
PR is done.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: psql and schemas
Next
From: Tom Lane
Date:
Subject: Re: Shared dependencies