Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1BDF79FB807 for ; Wed, 27 Jun 2007 13:52:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 50900-01 for ; Wed, 27 Jun 2007 13:52:21 -0300 (ADT) X-Greylist: delayed 00:18:36.285298 by SQLgrey-1.7.5 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 2D9A69FBED4 for ; Wed, 27 Jun 2007 13:52:21 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mycorporateemail.com (mycorporateemail.com [66.11.121.34]) by svr4.postgresql.org (Postfix) with ESMTP id 0104A5AF8A1 for ; Wed, 27 Jun 2007 16:33:43 +0000 (GMT) Received: from pitcher.impulsemg.com (pitcher.impulsemg.com [63.163.248.9]) by mycorporateemail.com (Postfix) with ESMTP id 52A9636D22 for ; Wed, 27 Jun 2007 02:28:49 -0400 (EDT) X-MimeOLE: Produced By Microsoft Exchange V6.0.6619.12 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C7B8D8.B45D79EC" Subject: Determine/Calculate table size Date: Wed, 27 Jun 2007 12:32:08 -0400 X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Determine/Calculate table size thread-index: Ace42OO993PrWB9ISwqEx1N3KbLwJA== From: "Nathaniel Banks Jr." To: Message-Id: <20070627163333.054BD69B21@pitcher.impulsemg.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200706/280 X-Sequence-Number: 25948 This is a multi-part message in MIME format. ------_=_NextPart_001_01C7B8D8.B45D79EC Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hello Gurus, I'm fairly new to Postgres and I was wondering what command/sql query will give me a list of each table in a schema with it's size? I've searched around and I haven't been able to find...I'm on postgres 7.3 by the way =20 =20 ------_=_NextPart_001_01C7B8D8.B45D79EC Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello Gurus,

I’m fairly new to Postgres and I was wondering = what command/sql query will give me a list of each table in a schema with = it’s size? I’ve searched around and I haven’t been able to = find…I’m on postgres 7.3 by the way

 

 

------_=_NextPart_001_01C7B8D8.B45D79EC--