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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
