pkg.soopen package index

brew / Rang 3642

pspg mit Homebrew, apk, apt, dnf, MacPorts, Nix, zypper installieren

Prüfe Installationswege, Executables, Metadaten und Sicherheitshinweise für pspg in AI-Agent-Workflows.

InstallationsbefehlSicherheitshinweise

Installation

Weitere Installationsbefehle

macOS

Homebrewverifiziert · 100%
brew install pspg

local Homebrew formula metadata

MacPortsverifiziert · 94%
sudo port install pspg

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

Linux

Alpine Linux apkverifiziert · 92%
sudo apk add pspg

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

Debian aptverifiziert · 92%
sudo apt install pspg

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

Fedora dnfverifiziert · 92%
sudo dnf install pspg

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

Nixverifiziert · 92%
nix profile install nixpkgs#pspg

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

openSUSE zypperverifiziert · 92%
sudo zypper install pspg

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

Überblick

Paketzusammenfassung

Unix pager optimized for psql

Befehle und Aliase

  • pspg

Verlauf

Projektgeschichte und Nutzung

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.

Projektgeschichte

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.

Adoptionsgeschichte

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.

Wie es verwendet wird

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.

Warum Paket-Nerds sich dafür interessieren

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.

Zeitleiste

  • 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.

Quellen

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

Sicherheitslage

Risikostufe: blue

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

Risikoklassifikator

blue Risiko · mittel Konfidenz · tool

Warum

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

Signale

  • text:sql

Installationsverhalten

  • In den Formelmetadaten ist kein Homebrew-Post-install-Hook erfasst.
  • Homebrew-Bottle-Metadaten sind für 6 Plattformziele verfügbar.
  • Installiert mit 3 Laufzeitabhängigkeiten.
  • Build-Metadaten listen 1 Build-Abhängigkeiten.

Empfohlene Prüfung

Prüfe vor unbeaufsichtigter Agent-Nutzung, ob das Tool Klartext-Credentials liest, Remote-Zustand schreibt, Artefakte veröffentlicht oder Plugins ausführt.

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

Installierte Executables

BefehlArtSichtbarkeitHinweis
pspgcliglobales Executable

Aktualität

Version und Aktualität

Diese Signale trennen das Alter der Seitengenerierung, Aktivität des Paketmanagers und Upstream-Release-Vergleich. Versionsrückstand wird nur gemeldet, wenn eine Evidenz-URL und vergleichbare Versionen vorhanden sind.

Seite generiert2026-09-19
Manager-Version5.8.16
Manager aktualisiert2026-09-13
lokale DatenOK
Upstreamaktuell
neueste erkannte Version5.8.16

https://github.com/okbob/pspg

  • OKEs wurden keine Aktualitätswarnungen generiert.

Installationsmetadaten

Paketmetadaten

Paketschlüsselbrew:pspg
Version5.8.16
PaketmanagerHomebrew
Paketmanager-Seitehttps://formulae.brew.sh/formula/pspg
Homepagehttps://github.com/okbob/pspg
Repositoryhttps://github.com/okbob/pspg
LizenzBSD-2-Clause
Quellarchivhttps://github.com/okbob/pspg/archive/refs/tags/5.8.16.tar.gz
Zuletzt aktualisiert2026-09-13T12:46:20Z
Pulseupdated
Abhängigkeitenlibpq, ncurses, readline
Build-Abhängigkeitenpkgconf
Bottleverfügbar (auf arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux)
Homebrew post-installnicht definiert
Dienstkeiner deklariert
EinschränkungenAdd the following line to your psql profile (e.g. ~/.psqlrc) \setenv PAGER pspg \pset border 2 \pset linestyle unicode

Registry-Fakten

Details aus der Quelldatenbank

Source DatabaseHomebrew formula API
Taphomebrew/core
Full Namepspg
Version Scheme0
Revision0
Head VersionHEAD
Bottle Stable Root URLhttps://ghcr.io/v2/homebrew/core
Deprecatedno
Disabledno
Keg Onlyno
URL Keys
  • head
  • stable

Source-Datenbank-Treffer

Andere Paketmanager-Einträge

Treffer stammen aus externen Paketmanager-Indizes und bleiben von lokalen Automic-Vault-Paketlinks getrennt.

Debian apt95%

pspg 5.8.9-1

PostgreSQL pager

https://github.com/okbob/pspg

sudo apt install pspg
  • Section: database
  • Architecture: amd64
  • 5 Abhängigkeiten
  • normalized package name match
  • Abgeglichen nach: 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
  • Abgeglichen nach: 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 Abhängigkeiten
  • normalized package name match
  • Abgeglichen nach: 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 Abhängigkeiten
  • 1 stellt bereit
  • normalized package name match
  • Abgeglichen nach: 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
  • Abgeglichen nach: 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 Abhängigkeiten
  • 1 stellt bereit
  • normalized package name match
  • Abgeglichen nach: 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 Abhängigkeiten
  • 1 stellt bereit
  • normalized package name match
  • Abgeglichen nach: 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
  • Abgeglichen nach: 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

Paketgraph

Links stammen aus dem lokalen Paketbeziehungsgraph, Ergänzungen, Abhängigkeitskanten, Ecosystem-Matches und Paket-Hub-Mitgliedschaft.

Verwandte Tools

  • ncursesRuntime dependency declared by Homebrew.
  • libpqRuntime dependency declared by Homebrew.
  • pkgconfBuild dependency declared by Homebrew.

Gleicher Workflow

  • moorShares pkgdb curated category or tags: cli, developer-tools, pager.
  • mostShares pkgdb curated category or tags: cli, developer-tools, pager.
  • sql-lintShares pkgdb curated category or tags: cli, database-tools, developer-tools, postgresql.
  • sqlbenchShares pkgdb curated category or tags: cli, database-tools, developer-tools, postgresql.
  • sql-migrateShares pkgdb curated category or tags: cli, database-tools, developer-tools.
  • sql-translatorShares pkgdb curated category or tags: cli, database-tools, developer-tools.

Quellspur

Aus Repository-Daten generiert

Diese Seite wird von av-web aus dem privaten Paket-SQLite-Artefakt bereitgestellt, das scripts/generate-pkg-sqlite.py erstellt.

Verwendete Quellen

  • 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