select relname, relpages from pg_class;
relname is the table name.
relpages is number of pages of 8 K that needs the table to be stored.
(sorry for my English)
yours
Cris..
----- Original Message -----
From: "Kris Kiger" <kris(at)musicrebellion(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Sent: Tuesday, May 20, 2003 4:58 PM
Subject: [ADMIN] Table size on disk
> Is there a good way to tell how much physical space a table takes on
> disk? Thanks
>
> Kris
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html