Re: Removing -'s (header) before records in psql

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 ...