Turn off pager for psql’s interactive output

TL;DR:

\pset pager 0

From the \pset section of the psql manual:

pager

Controls use of a pager program for query and psql help output. If the environment variable PAGER is set, the output is piped to the specified program. Otherwise a platform-dependent default (such as more) is used.

When the pager option is off, the pager program is not used. When the pager option is on, the pager is used when appropriate, i.e., when the output is to a terminal and will not fit on the screen. The pager option can also be set to always, which causes the pager to be used for all terminal output regardless of whether it fits on the screen. \pset pager without a value toggles pager use on and off.

Related Posts:

  1. PostgreSQL: Remotely connecting to Postgres instance using psql command
  2. When is K 1024 and when is it 1000?
  3. Dial pad to get phone number (with Android button images)
  4. Why is it not possible to fake an IP address?
  5. Authentication versus Authorization
  6. What is tail recursion?
  7. Visual List of iOS Fonts?
  8. How to get rid of the “No bootable medium found!” error in Virtual Box? [closed]
  9. ‘git’ is not recognized as an internal or external command
  10. What does “xmlns” in XML mean?
  11. How do I get my C# program to sleep for 50 msec?
  12. What is an idiomatic way of representing enums in Go?
  13. Why the range of int is -32768 to 32767?
  14. syntaxerror: “unexpected character after line continuation character in python” math
  15. Flash Player Projector post 2020
  16. How to update multiple columns in single update statement in DB2
  17. what does the __file__ variable mean/do?
  18. Error in .External.graphics R
  19. Assembly’s manifest definition does not match assembly reference
  20. “unrecognized selector sent to instance” error in Objective-C
  21. Java – No enclosing instance of type Foo is accessible
  22. Center Plot title in ggplot2
  23. what is the difference between OLE DB and ODBC data sources?
  24. How to use PHP’s password_hash to hash and verify passwords
  25. How to create a custom coder?
  26. Git push won’t do anything (everything up-to-date)
  27. How to use vmImage on pipeline using Azure DevOps Server?
  28. git add . -> still “nothing to commit” with new files
  29. git submodule add error: does not have a commit checked out
  30. “The certificate chain was issued by an authority that is not trusted” when connecting DB in VM Role from Azure website
  31. What’s the complete range for Chinese characters in Unicode?
  32. Is there an operation for not less than or not greater than in python?
  33. Resource interpreted as stylesheet but transferred with MIME type text/html (seems not related with web server)
  34. Background color for Tk in Python
  35. how to uninstall MinGW and make cygwin ‘make’ as deafult make program with gcc 3.8.1
  36. Cosine similarity and tf-idf
  37. Optional Parameters in Go?
  38. Postgresql: Scripting psql execution with password
  39. Android – Package Name convention
  40. How to execute an oracle stored procedure?
  41. How do I time a method’s execution in Java?
  42. -bash: export: `=’: not a valid identifier
  43. Error “The goal you specified requires a project to execute but there is no POM in this directory” after executing maven command
  44. Error in glm() in R
  45. What is a good Hash Function?
  46. Excel Filters – show only relevant values in the filter
  47. Unable to convert 3d ply file image to 2d image
  48. Get a random item from a JavaScript array
  49. Plotting horizontal and vertical lines in Mathematica
  50. Error while waiting for device: Time out after 300seconds waiting for emulator to come online
  51. How to transparent Unity3D custom shader?
  52. Converting string to integer VB.NET
  53. Remove node_modules from git in vscode
  54. How do you change session timeout in IIS 8.5?
  55. Is it valid to have a html form inside another html form?
  56. what is shortcut command to kill process in windows command?
  57. Differentiate between function overloading and function overriding
  58. How to print variable in sml?
  59. Why is the minidlna database not being refreshed?
  60. java.sql.SQLException: Fail to convert to internal representation
  61. Representing EOF in C code?
  62. How to disable an Android button?
  63. How to set initial value and auto increment in MySQL?
  64. Chrome Broweser: csi.gstatic.com keeps loading
  65. How do you convert an entire directory with ffmpeg?
  66. What’s the difference between sx and σx in the statistics calculations on a TI-Nspire?
  67. Apache Kafka vs Apache Storm
  68. How can an Admin access the Google Drive contents of all the users in a particular domain?
  69. PSEXEC, access denied errors
  70. How do you define a global function in C++?
  71. A _disk_id.pod file appears on a windows flash drive
  72. What standard do language codes of the form “zh-Hans” belong to?
  73. What is the proof of of (N–1) + (N–2) + (N–3) + … + 1= N*(N–1)/2 
  74. Merge posts plugin? [closed]
  75. database collation differences
  76. Add Woocommerce product to cart with Contact Form 7 [closed]
  77. How to See Everything in get_option()?
  78. How can I prevent the WordPress Importer from munging double-newline paragraph breaks to a single newline?
  79. A Compare And Distinction Essay Define To Beat Writer’s Block
  80. 27 Outstanding Faculty Essay Examples
  81. The Way To Write An Essay Outline In Four Steps
  82. How to hide subfolder of static pages in WordPress using htaccess
  83. Javascript: Add anchor hashtag to URL, and reload
  84. To remove rendering of menus and header, plugin or theme?
  85. How to Unban an IP properly with Fail2Ban
  86. How to see stdout of ansible commands?
  87. Difference between KVM and QEMU
  88. Top level domain/domain suffix for private network?
  89. Are SSD drives as reliable as mechanical drives (2013)?
  90. The Joel Test for system administrator jobs
  91. How do I rename a task in Task Scheduled on Windows Server 2008 R2
  92. How do I get the history of “apt-get install” on Ubuntu?
  93. Why does x86 represent 32bit when x64 represents 64bit? [closed]
  94. How to reload screenrc without restarting screen?
  95. How long before an s3 bucket can be created with same name after deletion?
  96. Software vs hardware RAID performance and cache usage
  97. How do high traffic sites service more than 65535 TCP connections?
  98. Using variables in Apache config files to reduce duplication?
  99. How to unify package installation tasks in ansible?
  100. Private IP address in public DNS

Leave a Comment

tech