Skip site navigation (1) Skip section navigation (2)

Re: Suggestion: additional system views

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Suggestion: additional system views
Date: 2004-10-31 23:49:47
Message-ID: cm3tn7$j9v$1@news.hub.org (view raw or flat)
Thread:
Lists: 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



In response to

Responses

pgsql-hackers by date

Next:From: Gavin SherryDate: 2004-11-01 00:04:21
Subject: Re: Using ALTER TABLESPACE in pg_dump
Previous:From: Bruce MomjianDate: 2004-10-31 23:42:36
Subject: Re: Using ALTER TABLESPACE in pg_dump

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group