Received: from nsi.edu (amethea.nsi.edu [198.133.185.9]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA67824 for ; Thu, 29 Jul 1999 14:32:45 -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 LAA02815; Thu, 29 Jul 1999 11:32:42 -0700 (PDT) Sender: reina@nsi.edu Message-ID: <37A09F65.CCE4770A@nsi.edu> Date: Thu, 29 Jul 1999 11:37:25 -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: Bill Brandt , "pgsql-sql@postgreSQL.org" , Bruce Momjian Subject: Re: [SQL] Formatting the output References: <37A08915.D5B83C85@nsi.edu> <19990729133403.A32362@draaw.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Bill Brandt wrote: > 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... > Bruce Momjian wrote: > How about psql -qt: > > #$ sql -qt test > select * from pg_language; > internal|f |f | 0|n/a > lisp |f |f | 0|/usr/ucb/liszt > C |f |f | 0|/bin/cc > sql |f |f | 0|postgres > > The manual page says -q turns off row count, but -t does. I will fix > that now. > Thanks. That works fine. -Tony