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

From Gaetano Mendola
Subject Re: Suggestion: additional system views
Date
Msg-id cm3tn7$j9v$1@news.hub.org
Whole thread Raw
In response to Re: Suggestion: additional system views  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Suggestion: additional system views
List pgsql-hackers
Josh Berkus wrote:
> 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.

I suggest to add on pg_functions and on pg_views too, the list of dependencies
with other objects.


Regards
Gaetano Mendola




pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Using ALTER TABLESPACE in pg_dump
Next
From: Gavin Sherry
Date:
Subject: Re: Using ALTER TABLESPACE in pg_dump