X-Original-To: pgsql-admin@postgresql.org Received: from rtlocal.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 14B69475C15 for ; Mon, 10 Mar 2003 04:45:39 -0500 (EST) Received: (qmail 31587 invoked from network); 10 Mar 2003 09:45:10 -0000 Received: from unknown (HELO system67.trade-india-local.com) (192.168.0.67) by infocom-236-129-del.trade-india.com with SMTP; 10 Mar 2003 09:45:10 -0000 From: Rajesh Kumar Mallah Organization: Infocom Network Limited To: Ogden Nefix , pgsql-admin@postgresql.org Subject: Re: Table Sizes Date: Mon, 10 Mar 2003 15:15:18 +0530 User-Agent: KMail/1.5 References: <3E6BA947.3050205@waste.org> In-Reply-To: <3E6BA947.3050205@waste.org> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200303101515.18859.mallah@trade-india.com> X-Archive-Number: 200303/81 X-Sequence-Number: 7729 use contrib/dbsize 1. select relation_size('schemaname.tablename'); 2. select database_size('databasename'); function 1 does not works with tablename in miXed CaSe. regds mallah. On Monday 10 Mar 2003 2:21 am, Ogden Nefix wrote: > Hi, > > Is it possible to find out the size of certain tables in PostgreSQL? If > so, how? > > Thank you > > Ogden > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > > -- Regds Mallah ---------------------------------------- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.