Received: from draaw.net (IDENT:qmailr@cougar.draaw.net [199.234.237.22]) by hub.org (8.9.3/8.9.3) with SMTP id NAA58228 for ; Thu, 29 Jul 1999 13:34:19 -0400 (EDT) (envelope-from bbrandt@draaw.net) Received: (qmail 32400 invoked by uid 501); 29 Jul 1999 17:34:03 -0000 Date: Thu, 29 Jul 1999 13:34:03 -0400 From: Bill Brandt To: "G. Anthony Reina" Cc: "pgsql-sql@postgreSQL.org" Subject: Re: [SQL] Formatting the output Message-ID: <19990729133403.A32362@draaw.net> References: <37A08915.D5B83C85@nsi.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.4us In-Reply-To: <37A08915.D5B83C85@nsi.edu>; from G. Anthony Reina on Thu, Jul 29, 1999 at 10:02:13AM -0700 Try: psql db01 -c "select tablename from pg_tables where tablename NOT LIKE '%pg%'" -t The -e makes it display the QUERY: line... so removing it fixes that problem... the -t tells it not to show the column headings and such... Bill On Thu, Jul 29, 1999 at 10:02:13AM -0700, G. Anthony Reina wrote: >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 > > > -- Liam Bill Brandt brandtwr@draaw.net http://www.draaw.net/