From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Suggestion: additional system views |
Date: | 2004-11-01 00:58:15 |
Message-ID: | 20041101005815.GH13884@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, Nov 01, 2004 at 12:49:47AM +0100, Gaetano Mendola wrote:
> 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.
pg_keywords
pg_sqlstates
Attached is a rough draft of the latter.
Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
Attachment | Content-Type | Size |
---|---|---|
sqlstate.sql | text/plain | 5.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2004-11-01 01:11:45 | Re: [PATCHES] [HACKERS] ARC Memory Usage analysis |
Previous Message | Bruce Momjian | 2004-11-01 00:28:51 | Re: Using ALTER TABLESPACE in pg_dump |