pspg is a terminal pager purpose-built for working with tabular data in the command line. Unlike standard pagers, it understands table structure and keeps your context intact while navigating large datasets.

Key capabilities include:

Frozen headers and columns - Keep row and column labels visible while scrolling through wide tables
Data sorting - Sort results by any numeric column directly within the pager
Search functionality - Find specific values within your data with case-sensitive or case-insensitive matching
Clipboard integration - Select and copy specific rows or columns to your clipboard
Multiple format support - Works with CSV, TSV, and database query output
Rich theming - Choose from various color schemes including mcview and FoxPro styles
Mouse support - Navigate and interact using mouse clicks and scrolling

Database integration works seamlessly with PostgreSQL's psql, MySQL, SQLite, pgcli, Trino, and other SQL clients. Simply set your PSQL_PAGER environment variable to use pspg as your default pager.

Installation is straightforward on most Linux distributions through package managers (apt, dnf, brew), and it runs well in WSL2 on Windows. The tool offers extensive configuration options for customizing appearance, behavior, and keyboard shortcuts to match your workflow preferences.

Apt