title: How to stop postgres from showing all rows in a table with thousands of lines
body: <p>How do I stop Postgres from trying to show all thousands of rows without having to close the cmd window?</p>
  
  <p>I am totally new to Postgresql and I am testing a table with thousands of rows, so when I run SELECT * FROM TableX, I have to keep holding enter until all rows show up. I understand that I can also select only a number of rows with a SQL statement, however, my question is how do I stop Postgres from trying to show all thousands of rows without having to close the cmd window.</p>