Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 71FC91337B6E for ; Thu, 9 Dec 2010 17:48:04 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 55010-09 for ; Thu, 9 Dec 2010 21:47:57 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from stan.prospectivdirect.com (mail.prospectiv.com [155.212.59.212]) by mail.postgresql.org (Postfix) with SMTP id 0B86F133655C for ; Thu, 9 Dec 2010 17:47:56 -0400 (AST) Received: (qmail 24262 invoked from network); 9 Dec 2010 21:47:55 -0000 Received: from unknown (HELO ?192.168.1.87?) (192.168.1.87) by 0 with SMTP; 9 Dec 2010 21:47:55 -0000 Subject: sqlplus reporting equivalent in postgres? From: Tony Capobianco To: pgsql-sql@postgresql.org Content-Type: text/plain; charset="UTF-8" Date: Thu, 09 Dec 2010 16:47:55 -0500 Message-ID: <1291931275.1746.15.camel@tony1.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.28.3 (2.28.3-1.fc12) Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/49 X-Sequence-Number: 34885 We're in the process of porting our Oracle 10.2 datawarehouse over to PostGres 8.4. One thing we rely upon are daily/hourly reports that are run and formatted in sqlplus (break on report, compute sum, etc.). Is there an equivalent available in postgres? Thanks. Tony