How can I show the output of psql commands correctly in a terminal emulator?

Question

I am using psql command line client in terminal emulator lxterminal in Ubuntu. When I run the following command the output is mess

students=# select * from information_schema.routines;

I wonder if it is possible to view the output in a terminal emulator as a nice table? Thanks.

Possible duplicate of Display select results vertically in psql, as is done by MySQL's \G — Oliver Charlesworth
– Oliver Charlesworth, Commented Jan 17, 2018 at 18:46

Vao Tsun · Accepted Answer · 2018-01-16 11:42:20Z

2

-x

--expanded

Turn on the expanded table formatting mode. This is equivalent to \x or \pset expanded.

answered Jan 16, 2018 at 11:42

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1