Re: psql show dbsize? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: psql show dbsize?
Date
Msg-id 200803071556.m27Fu8w16685@momjian.us
Whole thread Raw
In response to Re: psql show dbsize?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Added to TODO:
       o Have \l+ show database size, if permissions allow
         Ideally it will not generate an error for invalid permissions


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

Tom Lane wrote:
> "Brendan Jurd" <direvus@gmail.com> writes:
> > I'd find this convenient too.  Although \l+ would be more consistent
> > with the \d series of commands.
> 
> Putting it into \l+ would address my gripe about increased execution
> time.  The permissions angle still bothers me though.  AFAIR there are
> no psql catalog-inquiry backslash commands that require any special
> permissions, so making \l+ into something that's quite likely to fail
> in a locked-down installation seems out of place.
> 
> Is there a way to get it to just not print anything, instead of failing,
> for DBs you don't have privileges for?
> 
>             regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://postgres.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Commitfest status
Next
From: Teodor Sigaev
Date:
Subject: Re: Behaviour of to_tsquery(stopwords only)