Received: from nsi.edu (amethea.nsi.edu [198.133.185.9]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA52064 for ; Thu, 29 Jul 1999 12:57:32 -0400 (EDT) (envelope-from reina@nsi.edu) Received: from nsi.edu (o21.nsi.edu [204.128.156.216]) by nsi.edu (8.9.1/8.9.1) with ESMTP id JAA05489 for ; Thu, 29 Jul 1999 09:57:31 -0700 (PDT) Sender: reina@nsi.edu Message-ID: <37A08915.D5B83C85@nsi.edu> Date: Thu, 29 Jul 1999 10:02:13 -0700 From: "G. Anthony Reina" Organization: The Neurosciences Institute X-Mailer: Mozilla 4.07C-SGI [en] (X11; I; IRIX 6.5 IP32) MIME-Version: 1.0 To: "pgsql-sql@postgreSQL.org" Subject: Formatting the output Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Is there a way that I can supress the column heading and the "(# rows)" which come before and after the following psql command: psql -e db01 -c "select tablename from pg_tables where tablename NOT LIKE 'pg%'" The current output is: tablename ======= table1 table2 table3 table4 (4 rows) What I'd like to get is simply: table1 table2 table3 table4 Thanks. -Tony