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.

p.s. Here is a similar question for mysql: How can I show the output of mysql commands correctly in a terminal emulator?.

Answer 1

for "vertical" display, use \x https://www.postgresql.org/docs/current/static/app-psql.html

-x

--expanded

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