{"repo":"okbob/pspg","free":true,"listed":false,"github":"https://github.com/okbob/pspg","clone":"git clone https://github.com/okbob/pspg.git","description":"Unix pager (with very rich functionality) designed for work with tables. Designed for PostgreSQL, but MySQL is supported too. Works well with pgcli too. Can be used as CSV or TSV viewer too. It supports searching, selecting rows, columns, or block and export selected area to clipboard.","language":"C","stars":2729,"topics":["c","ncurses","tui","postgres-pager","postgresql","psql","terminal-pager","terminal-app","csv-viewer","mysql"],"license":"BSD-2-Clause","category":"databases-storage","readme_excerpt":"pspg - Postgres Pager Everybody who uses psql also uses the less pager. Which, while it works well, has no special support for tabular data. I found a few projects, but none was good enough for this purpose. Thus I decided to write a small specialized pager to use as a psql pager. This pager can be used from the following command line clients, too: - mysql - sqlite - pgcli - monetdb - Trino (formerly Presto SQL) - usql - sqlcl (for oracle) - nushell Main target ability to freeze the first few rows, or first few columns ability to sort data by the specified numeric column ability to use fancy themes - like mcview or FoxPro - http://okbob.blogspot.com/2019/12/pspg-themes-what-you-use-it.html mouse is supported and used ability to copy a selected range to the clipboard Installation and basic configuration The pspg can be simply installed from Debian (Ubuntu) repositories. RedHat (Fedora) repositories contains pspg too: # Debian (Ubuntu) sudo apt-get install pspg # RedHat (Fedora) sudo dnf install pspg Basic configuration is very simple - just set system environment variable PSQL PAGER : export PSQL PAGER='pspg' or with some common options ( -b means blackwhite theme, -X preserve content after exit): export PSQL PAGER='pspg -X -b' Attention: options used in command line has higher priority than options specified in configuration file ( /.pspgconf ). Native installation on MS Windows is not supported, but pspg works well inside wsl2 . Inside wsl2 environment, the installation is s","default_branch":null,"files":null,"tree":[],"storefront":"/r/okbob","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/okbob/pspg/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}