| From: | "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Table Sizes |
| Date: | 2003-03-14 20:21:56 |
| Message-ID: | 20030314202156.GB7004@wallace.ece.rice.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | P G | 2003-03-14 21:45:04 | Re: [GENERAL] Is there any procedure to start postgre database server automatically |
| Previous Message | Murthy Kambhampaty | 2003-03-14 19:45:01 | Follow-up RE: LVM snapshots |