Bruno Baguette wrote:
I works on a PostgreSQL 8.0.4 database, and I would like to known the
size (in bytes, Mbytes or anything else) of that database, for each
table.
You've already got several replies. Know that the PG documentation is
excellent. If you visit www.postgresql.org, you will qui
Bruno Baguette wrote:
Hello,
I works on a PostgreSQL 8.0.4 database, and I would like to known the
size (in bytes, Mbytes or anything else) of that database, for each table.
How can I do that ?
Thanks in advance !
This will probably work for you (in bytes - or you could divide by 8
inste
The space occupied by your database and tables can be found this way:# select oid from pg_database where datname='mybase'; oid --- 17239(1 row)$ du -hs data/base/17239
13.5 MFor getting a table size to get an approx size you can do the following:SELECT relpages * 8192 AS size_in_bytesFROM pg_c
Bruno Baguette <[EMAIL PROTECTED]> schrieb:
> Hello,
>
> I works on a PostgreSQL 8.0.4 database, and I would like to known the size
> (in bytes, Mbytes or anything else) of that database, for each table.
>
> How can I do that ?
I'm not sure if this functions available in 8.0:
If not, see in co
Bruno Baguette wrote:
Hello,
I works on a PostgreSQL 8.0.4 database, and I would like to known the
size (in bytes, Mbytes or anything else) of that database, for each
table.
How can I do that ?
Thanks in advance !
on contrib package or contrib subdir from the source is dbsize
leon
Hello,
I works on a PostgreSQL 8.0.4 database, and I would like to known the
size (in bytes, Mbytes or anything else) of that database, for each table.
How can I do that ?
Thanks in advance !
--
Bruno BAGUETTE
---(end of broadcast)---
TIP 5: d
