Re: Result output: how-to not have header and footers?

From: Christoph Dalitz <christoph(dot)dalitz(at)hs-niederrhein(dot)de>
To: jc(at)mega-bucks(dot)co(dot)jp
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Result output: how-to not have header and footers?
Date: 2002-09-05 07:11:10
Message-ID: 20020905091110.675dc1f1.christoph.dalitz@hs-niederrhein.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2002-09-05 07:16:48 7.3b1 installation
Previous Message Justin Clift 2002-09-05 07:03:41 Re: could not login as a root