From: | "G(dot) Anthony Reina" <reina(at)nsi(dot)edu> |
---|---|
To: | Bill Brandt <brandtwr-pgsql(at)draaw(dot)net>, "pgsql-sql(at)postgreSQL(dot)org" <pgsql-sql(at)postgreSQL(dot)org>, Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
Subject: | Re: [SQL] Formatting the output |
Date: | 1999-07-29 18:37:25 |
Message-ID: | 37A09F65.CCE4770A@nsi.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
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: <whatever> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Alan Dorman | 1999-07-29 18:37:54 | Re: [HACKERS] web-based front end development |
Previous Message | Don Baccus | 1999-07-29 17:55:40 | Re: [HACKERS] web-based front end development |
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 1999-07-30 00:30:38 | Re: [SQL] Formatting the output |
Previous Message | Bruce Momjian | 1999-07-29 17:43:42 | Re: [SQL] Formatting the output |