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

Unix pager optimized for psql. Version 5.8.16 via Homebrew; verified from local package data.

## Install

```sh
sudo av install brew:pspg
```

Additional install commands:

### macOS

- Homebrew (100%):

```sh
brew install pspg
```

  Evidence: local Homebrew formula metadata

- MacPorts (94%):

```sh
sudo port install pspg
```

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

### Linux

- apk (92%):

```sh
sudo apk add pspg
```

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

- Debian apt (92%):

```sh
sudo apt install pspg
```

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

- dnf (92%):

```sh
sudo dnf install pspg
```

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

- Nix (92%):

```sh
nix profile install nixpkgs#pspg
```

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

- zypper (92%):

```sh
sudo zypper install pspg
```

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

## Package facts

- **Package key:** brew:pspg
- **Package manager:** Homebrew
- **Package manager page:** <https://formulae.brew.sh/formula/pspg>
- **Version:** 5.8.16
- **Source summary:** Unix pager optimized for psql
- **Homepage:** <https://github.com/okbob/pspg>
- **Repository:** <https://github.com/okbob/pspg>
- **Upstream docs:** <https://github.com/okbob/pspg#readme>
- **License:** BSD-2-Clause
- **Source archive:** <https://github.com/okbob/pspg/archive/refs/tags/5.8.16.tar.gz>
- **Generated:** 2026-07-08T18:08:21+00:00

## Executables

- pspg (cli)
- pspg (alias)

## Dependencies

- libpq
- ncurses
- readline

## Build dependencies

- pkgconf

## Install behavior

- Post-install hook: not defined
- Caveats: Add the following line to your psql profile (e.g. ~/.psqlrc) \setenv PAGER pspg \pset border 2 \pset linestyle unicode
- Bottle: available on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux

## Freshness

- Page generated: 2026-07-08
- Package-manager version: 5.8.16
- Local data: ok
- Upstream repository: https://github.com/okbob/pspg
- Upstream latest detected: 5.8.16 (current)
- info: No package-manager update timestamp was available.

## Security Notes

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

- **Geiger risk:** blue / medium
- broad file, network, media, or database tool signal

## 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

## Other Package-Manager Records

- Debian apt - pspg - 5.8.9-1: normalized package name match | Debian stable package indexes: pspg from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | PostgreSQL pager | https://github.com/okbob/pspg
- Nix - pspg: normalized package name match | nixpkgs package indexes: pkgs/by-name/ps/pspg/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1
- Ubuntu apt - pspg - 5.8.1-1build2: normalized package name match | Ubuntu 24.04 LTS package indexes: pspg from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | PostgreSQL pager | https://github.com/okbob/pspg
- apk - pspg - 5.8.16-r0: normalized package name match | Alpine Linux edge package indexes: pspg from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | A unix pager optimized for psql | https://github.com/okbob/pspg
- apk - pspg-doc - 5.8.16-r0: normalized package name match | Alpine Linux edge package indexes: pspg-doc from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | A unix pager optimized for psql (documentation) | https://github.com/okbob/pspg
- dnf - pspg - 5.8.16-1.fc45: normalized package name match | Fedora Rawhide package metadata: pspg from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst | A unix pager optimized for psql | https://github.com/okbob/pspg
- zypper - pspg - 1.9.0-1.25: normalized package name match | openSUSE Tumbleweed package metadata: pspg from https://download.opensuse.org/tumbleweed/repo/oss/repodata/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst | Pager for PostgreSQL, MariaDB, Percona, and MySQL | https://github.com/okbob/pspg
- MacPorts - pspg: normalized package name match | MacPorts ports tree: databases/pspg/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1


## Related links

- [Source-control packages](https://www.automicvault.com/pkg/source-control-tools/) - Belongs to a source-control command family.
- [Secret-risk packages](https://www.automicvault.com/pkg/secret-risk-packages/) - Has protected-tool coverage, approval-gate, or non-low Geiger security signals.
- [Terminal utility packages](https://www.automicvault.com/pkg/terminal-utilities/) - Matched terminal and command-line workflow metadata.
- [Text processing packages](https://www.automicvault.com/pkg/text-processing-tools/) - Matched text, document, or structured-data processing metadata.
- [libpq](https://www.automicvault.com/pkg/brew/libpq/) - Runtime dependency declared by Homebrew.
- [ncurses](https://www.automicvault.com/pkg/brew/ncurses/) - Runtime dependency declared by Homebrew.
- [pkgconf](https://www.automicvault.com/pkg/brew/pkgconf/) - Build dependency declared by Homebrew.
- [moor](https://www.automicvault.com/pkg/brew/moor/) - Shares av.db curated category or tags: cli, developer-tools, pager.
- [most](https://www.automicvault.com/pkg/brew/most/) - Shares av.db curated category or tags: cli, developer-tools, pager.
- [cartridge-cli](https://www.automicvault.com/pkg/brew/cartridge-cli/) - Shares av.db curated category or tags: cli, database-tools, developer-tools.
- [tt](https://www.automicvault.com/pkg/brew/tt/) - Shares av.db curated category or tags: cli, database-tools, developer-tools.
- [csview](https://www.automicvault.com/pkg/brew/csview/) - Shares av.db curated category or tags: cli, csv, developer-tools.
- [csvprintf](https://www.automicvault.com/pkg/brew/csvprintf/) - Shares av.db curated category or tags: cli, csv, developer-tools.
- [dasel](https://www.automicvault.com/pkg/brew/dasel/) - Shares av.db curated category or tags: cli, csv, developer-tools.
- [dblab](https://www.automicvault.com/pkg/brew/dblab/) - Shares av.db curated category or tags: cli, developer-tools, postgresql.
- [pgcopydb](https://www.automicvault.com/pkg/brew/pgcopydb/) - Local metadata places this package in an adjacent workflow. Shared terms: cli, database, developer, developer-tools, libpq.
- [sqlsmith](https://www.automicvault.com/pkg/brew/sqlsmith/) - Local metadata places this package in an adjacent workflow. Shared terms: cli, database, developer, developer-tools, libpq.

## Combined YAML source

View the package source record on GitHub. [combined/pspg.yml](https://github.com/automic-vault/db/blob/main/combined/pspg.yml)


## Sources

- Nucleus package database
- Geiger risk classifier
- package-page enrichment
- package version freshness
- av.db category and tag curation
- package relationship graph
- external package-manager database matches
- cross-ecosystem install command graph
