Re: Views, views, views! (long)

On 2005-05-05, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> And, as Lance points out, these system views would help as a diagnostic view
> for support engineers. Actually, I'll second that; I've had cause to
> recommend the CVS system views more than a dozen times to pgsql newbies on
> IRC. For example, there is an easy query you can do using the new system
> views (thanks, Andrew!) to check what unindexed foriegn keys you have.

Another popular query that gets asked on IRC is "how do I find out what
permissions have been granted to user X?" Try doing _that_ one in the
system catalogs.

--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services