Re: Table Sizes

On Mon, Mar 10, 2003 at 03:15:18PM +0530, Rajesh Kumar Mallah wrote:
>
> use contrib/dbsize
>
> 1. select relation_size('schemaname.tablename');
> 2. select database_size('databasename');
>
>
> function 1 does not works with tablename in miXed CaSe.

Sure it does, you just need to put the quotes in the right place:

test=# select relation_size('public.foo');
 relation_size
---------------
          8192
(1 row)

test=# select relation_size('public."FooTwo"');
 relation_size
---------------
          8192
(1 row)

Ross