install

Additional install commands

macOS

Homebrewverified · 100%

brew install pspg

local Homebrew formula metadata

MacPortsverified · 94%

sudo port install pspg

MacPorts ports tree · databases/pspg/Portfile · source: api.github.com

Linux

Alpine Linux apkverified · 92%

sudo apk add pspg

Alpine Linux edge package indexes · pspg · source: dl-cdn.alpinelinux.org

Debian aptverified · 92%

sudo apt install pspg

Debian stable package indexes · pspg · source: deb.debian.org

Fedora dnfverified · 92%

sudo dnf install pspg

Fedora Rawhide package metadata · pspg · source: dl.fedoraproject.org

Nixverified · 92%

nix profile install nixpkgs#pspg

nixpkgs package indexes · pkgs/by-name/ps/pspg/package.nix · source: api.github.com

openSUSE zypperverified · 92%

sudo zypper install pspg

openSUSE Tumbleweed package metadata · pspg · source: download.opensuse.org

overview

Package summary

Unix pager optimized for psql

Project links

Commands and aliases

pspg

history

Project history and usage

pspg is a Unix terminal pager designed for browsing tabular output, especially results produced by PostgreSQL's psql client. It retains the familiar pager workflow while adding table-oriented navigation and presentation features.

Project history

The author created pspg after finding that less, although commonly used with psql, lacked special support for tabular output. The project developed from that specialized PostgreSQL pager into a richer table browser with CSV and TSV input, themes, searching, sorting, frozen rows and columns, clipboard export, streaming, and watch modes.

Adoption history

The official README documents availability through Debian and Ubuntu, Fedora, Homebrew, Alpine Linux, FreeBSD, OpenBSD, MacPorts, and other packaging channels. It also describes integrations with database clients including psql, MySQL, SQLite, pgcli, Trino, sqlcl, and usql.

How it is used

Users commonly set PSQL_PAGER to pspg, optionally with display flags. The program can also read files or pipelines directly, view CSV and TSV data, refresh query output in watch mode, and export selected table regions to the clipboard. Configuration defaults to ~/.pspgconf; PSPG_CONF can select another file.

Why package nerds care

pspg is notable in package-manager culture because it turns the conventional Unix pager slot into a table-aware database interface. Its presence across several operating-system repositories makes a specialized PostgreSQL-adjacent utility easy to add without replacing psql itself.

Timeline

Project origin: Created as a specialized alternative to less for psql table output.
2017: The official README links an author's article discussing early pspg use and presentation.
2019: The official README links an author's article about pspg themes.
Fedora 28 era: The official installation notes document availability in Fedora repositories.

Related projects

PostgreSQL psql supplies its primary pager integration point.
less is the conventional general-purpose pager that motivated pspg's table-aware design.
pgcli, MySQL, SQLite, Trino, usql, sqlcl, and nushell are documented integration targets.

Sources

Official project README: https://github.com/okbob/pspg#readme

security posture

Risk level: blue

broad file, network, media, or database tool signal.

Risk classifier

blue risk · medium confidence · tool

Why

broad file, network, media, or database tool signal

Signals

text:sql

Install behavior

No Homebrew post-install hook is recorded in formula metadata.
Homebrew bottle metadata is available for 6 platform targets.
Installs with 3 runtime dependencies.
Build metadata lists 1 build dependencies.

Recommended review

Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.

local files

Configuration and credential file locations

These source-backed paths show where this package keeps local settings or durable credentials. Automic Vault can use them as review targets for secret scanning, migration, and command approval.

Configuration files

Config paths the tool may read or write during local use.

Unix: ~/.pspgconf

executables

Installed executables

Command	Kind	Exposure	Note
`pspg`	cli	global executable

freshness

Version and freshness

These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.

page generated2026-09-19

manager version5.8.16

manager updated2026-09-13

local dataok

upstreamcurrent

latest detected5.8.16

https://github.com/okbob/pspg

okNo freshness warnings were generated.

install metadata

Package metadata

Package key	brew:pspg
Version	5.8.16
Package manager	Homebrew
Package manager page	https://formulae.brew.sh/formula/pspg
Homepage	https://github.com/okbob/pspg
Repository	https://github.com/okbob/pspg
License	BSD-2-Clause
Source archive	https://github.com/okbob/pspg/archive/refs/tags/5.8.16.tar.gz
Last updated	2026-09-13T12:46:20Z
Pulse	updated
Dependencies	libpq, ncurses, readline
Build dependencies	pkgconf
Bottle	available (on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux)
Homebrew post-install	not defined
Service	none declared
Caveats	Add the following line to your psql profile (e.g. ~/.psqlrc) \setenv PAGER pspg \pset border 2 \pset linestyle unicode

registry facts

Source database details

Source Database	Homebrew formula API
Tap	homebrew/core
Full Name	pspg
Version Scheme	0
Revision	0
Head Version	HEAD
Bottle Stable Root URL	https://ghcr.io/v2/homebrew/core
Deprecated	no
Disabled	no
Keg Only	no
URL Keys	head stable

source database matches

Other package-manager records

Matches are pulled from external package-manager indexes and kept separate from local Automic Vault package links.

Debian apt95%

pspg 5.8.9-1

PostgreSQL pager

https://github.com/okbob/pspg

sudo apt install pspg

Section: database
Architecture: amd64
5 dependencies
normalized package name match
Matched by: Pspg

Debian stable package indexes · deb.debian.org · Debian stable package indexes: pspg from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz

Nix95%

pspg

nix profile install nixpkgs#pspg

normalized package name match
Matched by: Pspg

nixpkgs package indexes · api.github.com · nixpkgs package indexes: pkgs/by-name/ps/pspg/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1

Ubuntu apt95%

pspg 5.8.1-1build2

PostgreSQL pager

https://github.com/okbob/pspg

sudo apt install pspg

Section: universe/database
Architecture: amd64
5 dependencies
normalized package name match
Matched by: Pspg

Ubuntu 24.04 LTS package indexes · archive.ubuntu.com · Ubuntu 24.04 LTS package indexes: pspg from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz

apk95%

pspg 5.8.16-r0

A unix pager optimized for psql

https://github.com/okbob/pspg

sudo apk add pspg

License: BSD-2-Clause
Architecture: x86_64
Source Package: pspg
1 dependencies
1 provides
normalized package name match
Matched by: Pspg

Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: pspg from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz

apk95%

pspg-doc 5.8.16-r0

A unix pager optimized for psql (documentation)

https://github.com/okbob/pspg

sudo apk add pspg-doc

License: BSD-2-Clause
Architecture: x86_64
Source Package: pspg
normalized package name match
Matched by: Pspg

Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: pspg-doc from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz

dnf95%

pspg 5.8.16-2.fc45

A unix pager optimized for psql

https://github.com/okbob/pspg

sudo dnf install pspg

License: LicenseRef-Callaway-BSD
Category: Unspecified
Architecture: x86_64
Source Package: pspg
7 dependencies
1 provides
normalized package name match
Matched by: Pspg

Fedora Rawhide package metadata · dl.fedoraproject.org · Fedora Rawhide package metadata: pspg from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/652278618dec9c023176a80c435a32a2c8154869fb0eb662c267a54df28d77d9-primary.xml.zst

zypper95%

pspg 5.8.16-1.3

Pager for PostgreSQL, MariaDB, Percona, and MySQL

https://github.com/okbob/pspg

sudo zypper install pspg

License: BSD-2-Clause
Category: Productivity/Text/Utilities
Architecture: x86_64
Source Package: pspg
6 dependencies
1 provides
normalized package name match
Matched by: Pspg

openSUSE Tumbleweed package metadata · download.opensuse.org · openSUSE Tumbleweed package metadata: pspg from https://download.opensuse.org/tumbleweed/repo/oss/repodata/d310d5a96106e1e8872a385adf98aaa23be9db5d80937a6717314e7e7f37715065c6c748ab7ccee6475d620b46979c0fe64235fc0c46988e17edf659578fcf31-primary.xml.zst

MacPorts95%

pspg

sudo port install pspg

normalized package name match
Matched by: Pspg

MacPorts ports tree · api.github.com · MacPorts ports tree: databases/pspg/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1

package graph

Links come from deterministic package relationships, av.db category and tag curation, ecosystem matches, and package hub membership.

source trail

Generated from repository data

This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.

Combined YAML source

View the package source record on GitHub.

combined/pspg.yml

Used sources

Geiger risk classifier
cross-ecosystem install command graph
curated configuration and credential file locations
curated package history
external package-manager database matches
package relationship graph
package version freshness
package-page enrichment
pkg.so package database
pkgdb category and tag curation

Install pspg with Homebrew, apk, apt, dnf, MacPorts, Nix, zypper

Additional install commands

macOS

Linux

Package summary

Project links

Commands and aliases

Project history and usage

Project history

Adoption history

How it is used

Why package nerds care

Timeline

Related projects

Sources

Risk level: blue

Risk classifier

Why

Signals

Install behavior

Recommended review

Configuration and credential file locations

Configuration files

Installed executables

Version and freshness

Package metadata

Source database details

Other package-manager records

Internal package links

Topical hubs

Related tools

Same workflow

Agent security guides

Generated from repository data

Combined YAML source

Used sources