On 20 Jan 2008, at 02:06, Tom Lane wrote:
Andrew Gilligan <[EMAIL PROTECTED]> 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.
I didn't run into the permissions issue while testing on 8.2.6, but
you're quite correct, after trying 8.3.x it fails entirely. Sorry.
On databases containing around 50 tables it seems to return in under
10ms, but I haven't been able to test with larger than that.
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.
Showing the size on \l+ probably makes more sense, but I imagine that
would require a very different approach due to the permissions changes?
Best regards,
-Andy
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
