X-Original-To: pgsql-admin@postgresql.org Received: from ece.rice.edu (ece.rice.edu [128.42.246.164]) by postgresql.org (Postfix) with ESMTP id 228D1475E9D for ; Fri, 14 Mar 2003 15:21:58 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by ece.rice.edu (Postfix) with SMTP id 993C768A9E for ; Fri, 14 Mar 2003 14:21:58 -0600 (CST) Received: from localhost (localhost [127.0.0.1]) by ece.rice.edu (Postfix) with ESMTP id 3D19868A99 for ; Fri, 14 Mar 2003 14:21:58 -0600 (CST) Received: from wallace.ece.rice.edu (cnx-246-68.ece.rice.edu [128.42.246.68]) by ece.rice.edu (Postfix) with ESMTP id D96E968A82 for ; Fri, 14 Mar 2003 14:21:56 -0600 (CST) Received: from reedstrm by wallace.ece.rice.edu with local (Exim 3.36 #1 (Debian)) id 18tvgi-00022z-00 for ; Fri, 14 Mar 2003 14:21:56 -0600 Date: Fri, 14 Mar 2003 14:21:56 -0600 From: "Ross J. Reedstrom" To: pgsql-admin@postgresql.org Subject: Re: Table Sizes Message-ID: <20030314202156.GB7004@wallace.ece.rice.edu> Mail-Followup-To: "Ross J. Reedstrom" , pgsql-admin@postgresql.org References: <3E6BA947.3050205@waste.org> <200303101515.18859.mallah@trade-india.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200303101515.18859.mallah@trade-india.com> User-Agent: Mutt/1.4i X-Virus-Scanned: by AMaViS snapshot-20020300 X-DCC--Metrics: ece.rice.edu 1067; Body=1 Fuz1=1 Fuz2=1 X-Archive-Number: 200303/238 X-Sequence-Number: 7878 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