psql show dbsize?

From: andy <andy(at)squeakycode(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: psql show dbsize?
Date: 2007-10-31 18:49:39
Message-ID: 4728CE43.4040708@squeakycode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I know its way too late in the game, sorry, but it's a very small patch...

I was wondering if this could be added to 8.3: it adds the dbsize to \l
in psql.

It looks like this:

List of databases
Name | Owner | Encoding | Dbsize
-----------+----------+----------+---------
andy | andy | LATIN1 | 4255 kB
cramd | andy | LATIN1 | 526 MB
postgres | postgres | LATIN1 | 4263 kB
template0 | postgres | LATIN1 | 4136 kB
template1 | postgres | LATIN1 | 4255 kB
(5 rows)

pretty nice, huh?

-Andy

Attachment Content-Type Size
psqldbsize.patch text/plain 433 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2007-10-31 20:12:51 Re: AutoVacuum Behaviour Question
Previous Message Heikki Linnakangas 2007-10-31 17:56:09 Re: Postgresql 8.3 beta crash