Formatting the output

From: "G(dot) Anthony Reina" <reina(at)nsi(dot)edu>
To: "pgsql-sql(at)postgreSQL(dot)org" <pgsql-sql(at)postgreSQL(dot)org>
Subject: Formatting the output
Date: 1999-07-29 17:02:13
Message-ID: 37A08915.D5B83C85@nsi.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-07-29 17:02:34 Re: [HACKERS] web-based front end development
Previous Message Vince Vielhaber 1999-07-29 16:55:21 Re: [HACKERS] web-based front end development

Browse pgsql-sql by date

  From Date Subject
Next Message Bill Brandt 1999-07-29 17:34:03 Re: [SQL] Formatting the output
Previous Message Remigiusz Sokolowski 1999-07-29 06:50:05 test, please ignore