Postgres Pro
Downloads
Home   >   mailing lists

Re: Result output: how-to not have header and footers? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Result output: how-to not have header and footers?
Date
Msg-id 200209041739.g84Hdlg11329@candle.pha.pa.us
Whole thread Raw
In response to Result output: how-to not have header and footers?  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
List pgsql-general
Tree view 
Jean-Christian Imbeault wrote:
> Is it possible in postgresQL to get a query to return only values
> without the usual column identifiers header and number of results footer
> lines?
>
> I'm trying to pipe the output of a command line query and the
> header/footers are causing problems :)

Sure, psql -t.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: Jean-Christian Imbeault
Date:
Subject: Result output: how-to not have header and footers?
Next
From: Patrik Kudo
Date:
Subject: Re: Two large files instead of one?