macOS
Homebrew已验证 · 100%
brew install pspglocal Homebrew formula metadata
MacPorts已验证 · 94%
sudo port install pspgMacPorts ports tree · databases/pspg/Portfile · 来源: api.github.com
安装
其他安装命令
Linux
Alpine Linux apk已验证 · 92%
sudo apk add pspgAlpine Linux edge package indexes · pspg · 来源: dl-cdn.alpinelinux.org
Fedora dnf已验证 · 92%
sudo dnf install pspgFedora Rawhide package metadata · pspg · 来源: dl.fedoraproject.org
Nix已验证 · 92%
nix profile install nixpkgs#pspgnixpkgs package indexes · pkgs/by-name/ps/pspg/package.nix · 来源: api.github.com
openSUSE zypper已验证 · 92%
sudo zypper install pspgopenSUSE Tumbleweed package metadata · pspg · 来源: download.opensuse.org
概览
软件包摘要
Unix pager optimized for psql
历史
项目历史与用法
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.
项目历史
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.
采用历史
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.
使用方式
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.
为什么软件包爱好者会关心
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.
时间线
- 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.
来源
- Official project README: https://github.com/okbob/pspg#readme
安全态势
风险级别：blue
broad file, network, media, or database tool signal.
风险分类器
blue 风险 · 中 置信度 · tool
原因
- broad file, network, media, or database tool signal
信号
- text:sql
安装行为
- formula 元数据中未记录 Homebrew post-install 钩子。
- Homebrew bottle 元数据适用于 6 个平台目标。
- 安装时包含 3 个运行时依赖。
- 构建元数据列出 1 个构建依赖。
建议审查
在无人值守的代理使用前，请检查该工具是否读取明文凭据、写入远程状态、发布制品或调用插件。
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
可执行文件
已安装的可执行文件
| 命令 | 类型 | 暴露范围 | 备注 |
|---|---|---|---|
pspg | cli | 全局可执行文件 |
新鲜度
版本和新鲜度
这些信号区分页生成时间、软件包管理器活动和上游发布比较。只有存在证据 URL 和可比较版本时，才会提示版本落后。
页面生成时间2026-09-19
管理器版本5.8.16
管理器更新时间2026-09-13
本地数据OK
上游当前
检测到的最新版本5.8.16
- OK没有生成新鲜度警告。
安装元数据
软件包元数据
| 软件包键 | brew:pspg |
|---|---|
| 版本 | 5.8.16 |
| 软件包管理器 | Homebrew |
| 软件包管理器页面 | https://formulae.brew.sh/formula/pspg |
| 主页 | https://github.com/okbob/pspg |
| 仓库 | https://github.com/okbob/pspg |
| 许可证 | BSD-2-Clause |
| 源码归档 | https://github.com/okbob/pspg/archive/refs/tags/5.8.16.tar.gz |
| 最后更新 | 2026-09-13T12:46:20Z |
| Pulse | updated |
| 依赖 | libpq, ncurses, readline |
| 构建依赖 | pkgconf |
| Bottle | 可用 (于 arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux) |
| Homebrew post-install | 未定义 |
| 服务 | 未声明 |
| 注意事项 | Add the following line to your psql profile (e.g. ~/.psqlrc) \setenv PAGER pspg \pset border 2 \pset linestyle unicode |
注册表事实
源数据库详情
| 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 |
|
源数据库匹配
其他软件包管理器记录
匹配项来自外部软件包管理器索引，并与本地 Automic Vault 软件包链接分开显示。
Debian apt95%
pspg 5.8.9-1
PostgreSQL pager
sudo apt install pspg- Section: database
- Architecture: amd64
- 5 依赖
- normalized package name match
- 匹配方式：Pspg
Nix95%
pspg
nix profile install nixpkgs#pspg- normalized package name match
- 匹配方式：Pspg
Ubuntu apt95%
pspg 5.8.1-1build2
PostgreSQL pager
sudo apt install pspg- Section: universe/database
- Architecture: amd64
- 5 依赖
- normalized package name match
- 匹配方式：Pspg
apk95%
pspg 5.8.16-r0
A unix pager optimized for psql
sudo apk add pspg- License: BSD-2-Clause
- Architecture: x86_64
- Source Package: pspg
- 1 依赖
- 1 提供
- normalized package name match
- 匹配方式：Pspg
apk95%
pspg-doc 5.8.16-r0
A unix pager optimized for psql (documentation)
sudo apk add pspg-doc- License: BSD-2-Clause
- Architecture: x86_64
- Source Package: pspg
- normalized package name match
- 匹配方式：Pspg
dnf95%
pspg 5.8.16-2.fc45
A unix pager optimized for psql
sudo dnf install pspg- License: LicenseRef-Callaway-BSD
- Category: Unspecified
- Architecture: x86_64
- Source Package: pspg
- 7 依赖
- 1 提供
- normalized package name match
- 匹配方式：Pspg
zypper95%
pspg 5.8.16-1.3
Pager for PostgreSQL, MariaDB, Percona, and MySQL
sudo zypper install pspg- License: BSD-2-Clause
- Category: Productivity/Text/Utilities
- Architecture: x86_64
- Source Package: pspg
- 6 依赖
- 1 提供
- normalized package name match
- 匹配方式：Pspg
MacPorts95%
pspg
sudo port install pspg- normalized package name match
- 匹配方式：Pspg
来源线索
由仓库数据生成
此页面由 av-web 从 scripts/generate-pkg-sqlite.py 生成的私有软件包 SQLite 工件提供。
Combined YAML source
View the package source record on GitHub.
使用的来源
- 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