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 ... ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
