pspg
A Unix pager with rich table browsing features, designed for PostgreSQL but supporting MySQL, SQLite, and other database clients.
What is pspg?
pspg is a Unix pager specifically designed for browsing and interacting with tabular data from command-line database clients. It replaces generic pagers like `less` with features tailored for tables, such as freezing rows/columns, sorting, theme support, and clipboard export. It solves the problem of poorly formatted table navigation in terminal environments.
Database administrators, developers, and data analysts who regularly use command-line SQL clients (e.g., psql, mysql) and need efficient table browsing and data export capabilities directly in the terminal.
Developers choose pspg for its specialized table features, rich customization (themes, keybindings), and broad client support, offering a significantly better experience than generic pagers when working with SQL query results or CSV files.
Overview
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.
Use Cases
Best For
- Browsing large PostgreSQL query results in psql
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
