For example, I can get rid of the vertical bars with \pset border 0
Code: Select all
dbadmin=> select * from test_table;
name | age
-------+-----
Pat | 29
Brian | 14
Jim | 9
Tom | 53
Mark | 100
(5 rows)
dbadmin=> \pset border 0
Border style is 0.
dbadmin=> select * from test_table;
name age
----- ---
Pat 29
Brian 14
Jim 9
Tom 53
Mark 100
(5 rows)
Code: Select all
dbadmin=> \pset format unaligned
Output format is unaligned.
dbadmin=> \pset fieldsep ,
Field separator is ",".
dbadmin=> \pset tuples_only
Showing only tuples.
dbadmin=> select * from test_table;
Pat,29
Brian,14
Jim,9
Tom,53
Mark,100
dbadmin=>