From: | Bill Brandt <brandtwr-pgsql(at)draaw(dot)net> |
---|---|
To: | "G(dot) Anthony Reina" <reina(at)nsi(dot)edu> |
Cc: | "pgsql-sql(at)postgreSQL(dot)org" <pgsql-sql(at)postgreSQL(dot)org> |
Subject: | Re: [SQL] Formatting the output |
Date: | 1999-07-29 17:34:03 |
Message-ID: | 19990729133403.A32362@draaw.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
Try:
psql db01 -c "select tablename from pg_tables where tablename NOT LIKE '%pg%'" -t
The -e makes it display the QUERY: <whatever> 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(at)draaw(dot)net http://www.draaw.net/
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-07-29 17:41:54 | Re: [SQL] Formatting the output |
Previous Message | Bruce Momjian | 1999-07-29 17:08:38 | Re: [PORTS] RedHat6.0 & Alpha |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-07-29 17:41:54 | Re: [SQL] Formatting the output |
Previous Message | G. Anthony Reina | 1999-07-29 17:02:13 | Formatting the output |