Re: Suggestion: additional system views

I do like this idea. Can you make a general patch? Do others like the
idea of system tables showing error codes and keywords?

---------------------------------------------------------------------------

David Fetter wrote:
> 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, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073