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

Re: Suggestion: additional system views

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Neil Conway <neilc(at)samurai(dot)com>
Subject: Re: Suggestion: additional system views
Date: 2004-10-29 03:07:43
Message-ID: 200410282007.43934.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2004-10-29 03:41:28
Subject: Re: Shared dependencies
Previous:From: Neil ConwayDate: 2004-10-29 01:55:06
Subject: psql and schemas

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