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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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