Re: Removing -'s (header) before records in psql - Mailing list pgsql-general

On Sun, 14 Aug 2005, CSN wrote:

> Is it possible to get rid of the "header" of -'s when
> selecting rows in psql? For fields with a lot of text,
> it looks like:
>

All I'm familiar with is \t which will return only tuples, so you'll lose
the headings as well.

Otherwise pipe through sed/head/tail to filter appropriately?


Brent Wood


>  select body from news where id=123;
> -[ RECORD 1
>
]--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------!
 ---
>  --------
>
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------!
 ---
>  --------
>
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------!
 ---
>  --------
>
-------------------------------------------------------------------------------------------------------------------------------------------------------------
> body | Additional details ...