# 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. Also installable with debian: sudo apt install pspg.

## 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/210a2053c8e007daf9ae39c2a21daaed9b2ddd07d63ecffa597050361e73650c-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/50b07339cb64c8ed4091bdbabddadc1ff5737b090e478818a195b40d8a3292861a879139b4a3987c31109699fde9fbf4a716367ddf4eef77da75f96e3193d6ed-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>
- **License:** BSD-2-Clause
- **Source archive:** <https://github.com/okbob/pspg/archive/refs/tags/5.8.16.tar.gz>
- **Generated:** 2026-08-04T22:13:35+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-08-04
- 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-2.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/210a2053c8e007daf9ae39c2a21daaed9b2ddd07d63ecffa597050361e73650c-primary.xml.zst | A unix pager optimized for psql | https://github.com/okbob/pspg
- zypper - pspg - 5.8.16-1.3: normalized package name match | openSUSE Tumbleweed package metadata: pspg from https://download.opensuse.org/tumbleweed/repo/oss/repodata/50b07339cb64c8ed4091bdbabddadc1ff5737b090e478818a195b40d8a3292861a879139b4a3987c31109699fde9fbf4a716367ddf4eef77da75f96e3193d6ed-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://pkg.so/source-control-tools/) - Belongs to a source-control command family.
- [Secret-risk packages](https://pkg.so/secret-risk-packages/) - Has protected-tool coverage, approval-gate, or non-low Geiger security signals.
- [Terminal utility packages](https://pkg.so/terminal-utilities/) - Matched terminal and command-line workflow metadata.
- [Text processing packages](https://pkg.so/text-processing-tools/) - Matched text, document, or structured-data processing metadata.
- [ncurses](https://pkg.so/brew/ncurses/) - Runtime dependency declared by Homebrew.
- [libpq](https://pkg.so/brew/libpq/) - Runtime dependency declared by Homebrew.
- [pkgconf](https://pkg.so/brew/pkgconf/) - Build dependency declared by Homebrew.
- [moor](https://pkg.so/brew/moor/) - Shares pkgdb curated category or tags: cli, developer-tools, pager.
- [most](https://pkg.so/brew/most/) - Shares pkgdb curated category or tags: cli, developer-tools, pager.
- [sql-lint](https://pkg.so/brew/sql-lint/) - Shares pkgdb curated category or tags: cli, database-tools, developer-tools, postgresql.
- [sqlbench](https://pkg.so/brew/sqlbench/) - Shares pkgdb curated category or tags: cli, database-tools, developer-tools, postgresql.
- [sql-migrate](https://pkg.so/brew/sql-migrate/) - Shares pkgdb curated category or tags: cli, database-tools, developer-tools.
- [sqlancer](https://pkg.so/brew/sqlancer/) - Shares pkgdb curated category or tags: cli, database-tools, developer-tools.
- [sql-translator](https://pkg.so/brew/sql-translator/) - Shares pkgdb curated category or tags: cli, database-tools, developer-tools.
- [yq](https://pkg.so/brew/yq/) - Shares pkgdb curated category or tags: cli, csv, developer-tools.
- [pgcopydb](https://pkg.so/brew/pgcopydb/) - 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/mxcl/pkgdb/blob/main/combined/pspg.yml)


## Sources

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