# okbob/pspg

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.

Repository: https://github.com/okbob/pspg
Canonical: https://ross.abutalabs.com/products/pspg
Language: C
License: BSD-2-Clause
License Family: permissive
Topics: c, ncurses, tui, postgres-pager, postgresql, psql, terminal-pager, terminal-app, csv-viewer, mysql, dbcli, monetdb-client, postgresql-client, mysql-client, pager, nushell, terminal
Last push: 2026-06-28T06:36:42+00:00

## Health v2 (maintenance only)
Score: 81/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 89, release rhythm 59, longevity 100
- inputs: {"age_days": 3340, "days_push": 66, "days_rel": 196, "gap_med": 36, "n_releases_24m": 10}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 2728, forks 89 (observed 2026-08-28T04:07:15.966493+00:00)

## What it is
pspg is a Unix terminal pager written in C with rich functionality designed for browsing tabular data, primarily as a pager for psql and PostgreSQL. It also works with MySQL, sqlite, pgcli, and other CLI database clients, and can view CSV/TSV files with features like frozen rows/columns, sorting, searching, and clipboard export.

## Use cases
- view psql query results in a pager with frozen header rows
- browse CSV files in the terminal
- sort query output by a numeric column
- copy selected table cells to clipboard from the terminal
- use a table-aware pager with pgcli or mysql
- search within large query result sets

## When to choose
- you spend a lot of time in psql, mysql, or pgcli and want better table navigation than less
- you need a terminal CSV/TSV viewer with sorting and selection
- you want to freeze header rows or columns while scrolling wide result sets

## When to avoid
- you need a general-purpose pager for non-tabular text
- you need a native Windows application (use WSL2 instead)
- you need a GUI table viewer

## Facets
- artifact type: cli-tool
- maturity: active
- function: cli, developer-tools
- domain: databases, developer-tools
- platform: cli, cross-platform
- tags: pager, tui, ncurses, psql, csv-viewer, terminal-ui, postgresql, mysql, command-line, linux, macos

## Member repositories
- okbob/pspg (main) score 81

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:07:15.966493+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T02:14:43.272940+00:00, confidence not recorded.
  - readme: https://github.com/okbob/pspg (fetched 2026-08-28T04:07:15.966493+00:00, sha 7608d0768992)
- Data as of 2026-08-30T08:39:29.467469+00:00.