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

From Christoph Dalitz
Subject Re: Result output: how-to not have header and footers?
Date
Msg-id 20020905091110.675dc1f1.christoph.dalitz@hs-niederrhein.de
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
>
> 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 :)
>
you can fine tune the format of query results in psql wiht \pset, eg.

    \pset unaligned
    \pset fieldsep |
    \pset tuples_only


See the man page of psql for details.

Christoph Dalitz

pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Re: could not login as a root
Next
From: Jeff Davis
Date:
Subject: 7.3b1 installation