How to fix crooked columns displayed in Postrgresql?

Started to read the book of Ben Forta SQL. With the book data is provided to populate the database.
And for multiple tables, for example,

CREATE TABLE Vendors
(
 vend_id char(10) NOT NULL ,
 vend_name char(50) NOT NULL ,
 vend_address char(50) NULL ,
 vend_city char(50) NULL ,
 vend_state char(5) NULL ,
 vend_zip char(10) NULL ,
 vend_country char(50) NULL 
);


after you create and populate the result is a very curved display:
5b51df4b07800173764693.jpeg

Is there a way to fix it?
(system is Ubuntu)
June 3rd 19 at 19:21
1 answer
June 3rd 19 at 19:23
Solution
You have a terminal narrow to your selection.
The broad results are often easier to read in wide view, which is toggled by the commands \x in psql:

melkij=> select generate_series(1,3);
 generate_series 
-----------------
1
2
3
(3 rows)

melkij=> \x
Extended output is enabled.
melkij=> select generate_series(1,3);
-[ RECORD 1 ]---+--
generate_series | 1
-[ RECORD 2 ]---+--
generate_series | 2
-[ RECORD 3 ]---+--
generate_series | 3
Thank you very much, helped! - elroy commented on June 3rd 19 at 19:26

Find more questions by tags PostgreSQL