Re: [PATCH] Add size/acl information when listing databases

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Gilligan <andy(at)tcpd(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCH] Add size/acl information when listing databases
Date: 2008-01-20 02:06:59
Message-ID: 2015.1200794819@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andrew Gilligan <andy(at)tcpd(dot)net> writes:
> Attached is a rather small change to src/bin/psql/describe.c to
> show database size and permissions when using the psql \l command.

Doesn't this slow down \l by several orders of magnitude? There's
also the small problem that the query will fail entirely if there are
any databases the current user cannot connect to.

The ACL part is fine, the database size not so much. I could see
relegating the size to a \l+ option, but you still have to deal with the
permissions problem.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-01-20 02:11:28 Re: message string fixes
Previous Message Andrew Gilligan 2008-01-20 01:12:41 [PATCH] Add size/acl information when listing databases