Re: [GENERAL] dbsize command

2008-06-23 Thread Leif B. Kristensen
On Monday 23. June 2008, salman wrote: >This is what I use: SELECT >pg_size_pretty(pg_database_size(current_database())); Great, I remember that I saw it, but couldn't remember the command. Now I've made a function: CREATE OR REPLACE FUNCTION db_size() RETURNS TEXT AS $$ SELECT pg_size_pret

Re: [GENERAL] dbsize command

2008-06-23 Thread salman
Brad Nicholson wrote: On Mon, 2008-06-23 at 10:50 -0700, Reynolds, Gregory A wrote: In past versions there was a contrib/dbsize command that would tell you how much storage space was being taken by a table. Is that is still a supported feature in 8.3, and if so what is the syntax or where is th

Re: [GENERAL] dbsize command

2008-06-23 Thread Brad Nicholson
On Mon, 2008-06-23 at 10:50 -0700, Reynolds, Gregory A wrote: > In past versions there was a contrib/dbsize command that would tell > you how much storage space was being taken by a table. Is that is > still a supported feature in 8.3, and if so what is the syntax or > where is the documentation on

Re: [GENERAL] dbsize command

2008-06-23 Thread Greg Smith
On Mon, 23 Jun 2008, Reynolds, Gregory A wrote: In past versions there was a contrib/dbsize command that would tell you how much storage space was being taken by a table. Is that is still a supported feature in 8.3, and if so what is the syntax or where is the documentation on how to use it? T