How can i avoid skipping rows when i use select * from table?

Question

I want to check if everything is on the table but using the command

select * from table_name

Some of the rows are skipped(skipping) because they are so many. How can i see them all?

Answer 1

In psql it is possible to pipe the query output to a file:

=> \o 'query-result.txt'
=> select * from t;

Now open the file in your favorite text editor

A second \o will turn the output back to the terminal