Re: Views, views, views! (long)

On 2005-05-05, Josh Berkus <josh@agliodbs.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