brew / 排名 2805

使用 Homebrew, apt, Nix, pacman, MacPorts 安装 pgformatter

查看 pgformatter 的安装路径、可执行文件、元数据以及面向 AI 代理工作流的安全说明。

安装命令安全说明

安装

其他安装命令

macOS

Homebrew已验证 · 100%

brew install pgformatter

local Homebrew formula metadata

MacPorts已验证 · 94%

sudo port install pgFormatter

MacPorts ports tree · databases/pgFormatter/Portfile · 来源: api.github.com

Linux

Debian apt已验证 · 92%

sudo apt install pgformatter

Debian stable package indexes · pgformatter · 来源: deb.debian.org

Nix已验证 · 92%

nix profile install nixpkgs#pgformatter

nixpkgs package indexes · pkgs/by-name/pg/pgformatter/package.nix · 来源: api.github.com

Arch Linux pacman已验证 · 92%

sudo pacman -S pgformatter

Arch Linux sync databases · pgformatter · 来源: geo.mirror.pkgbuild.com

概览

软件包摘要

PostgreSQL syntax beautifier

项目链接

命令和别名

pg_format

历史

项目历史与用法

pgFormatter is Gilles Darold's formatter for PostgreSQL SQL and PL/pgSQL, usable as the `pg_format` console program or as a CGI and online formatter.

项目历史

Gilles Darold created pgFormatter as a PostgreSQL SQL and PL/pgSQL beautifier; official source copyright begins in 2012. The project incorporates a modified SQL::Beautify module and credits substantial later refactoring by Hubert Lubaczewski.

The project evolved beyond basic pretty-printing to support multiple SQL standards, PostgreSQL-specific syntax, configurable casing and indentation, anonymization, placeholders, editor integrations, a JSON-capable CGI interface, and automated hook workflows.

采用历史

pgFormatter is packaged by Homebrew, Debian, Ubuntu, MacPorts, Nix, and Arch Linux according to source_facts.package-manager. Its repository also supplies a pre-commit hook definition and documents editor, container, and automation workflows.

使用方式

Users format one or more files or stdin with `pg_format`, write to stdout or a selected output, or update files in place. Persistent options can be stored in a project-local, home-directory, or XDG configuration file.

Common workflows include editor format commands, pre-commit hooks, CI checks, Docker pipelines, anonymizing literals before sharing SQL, and the official web/CGI formatter.

为什么软件包爱好者会关心

pgFormatter fills for PostgreSQL SQL a role analogous to established language formatters: it makes formatting repeatable in editors, hooks, scripts, and CI while understanding PostgreSQL-specific SQL and PL/pgSQL constructs.

Its combination of a Perl CLI, CGI interface, online formatter, stdin/stdout operation, in-place editing, and persistent configuration makes it especially composable in Unix-oriented development environments.

时间线

2012: Official source copyright begins for Gilles Darold's pgFormatter.
2018: PostgreSQL community news recorded the pgFormatter 3.0 release.
2020s: The project added broader PostgreSQL syntax support, XDG configuration discovery, and native pre-commit integration.

Related projects

The repository includes a native pre-commit hook that invokes `pg_format --inplace`, allowing formatting to run automatically in Git workflows.

来源

Official CLI source and copyright: https://github.com/darold/pgFormatter/blob/master/lib/pgFormatter/CLI.pm
Official README: https://github.com/darold/pgFormatter#readme
Official hook definition: https://github.com/darold/pgFormatter/blob/master/.pre-commit-hooks.yaml
Package adoption: source_facts.package-manager

安全态势

尚未找到受保护工具覆盖

没有找到 pgformatter 的匹配本地密钥处理 manifest。软件包元数据仍在此发布，以便未来覆盖拥有稳定的软件包 URL。

安装行为

formula 元数据中未记录 Homebrew post-install 钩子。
Homebrew bottle 元数据适用于 6 个平台目标。

建议审查

在无人值守的代理使用前，请检查该工具是否读取明文凭据、写入远程状态、发布制品或调用插件。

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: ./.pg_format~/.pg_format$XDG_CONFIG_HOME/pg_format/pg_format.conf
Windows: ./.pg_format%USERPROFILE%\.pg_format

可执行文件

已安装的可执行文件

命令	类型	暴露范围	备注
`pg_format`	cli	全局可执行文件

新鲜度

版本和新鲜度

这些信号区分页生成时间、软件包管理器活动和上游发布比较。只有存在证据 URL 和可比较版本时，才会提示版本落后。

页面生成时间2026-11-04

管理器版本5.11

管理器更新时间2026-09-13

本地数据OK

上游当前

检测到的最新版本v5.11

https://github.com/darold/pgFormatter

OK没有生成新鲜度警告。

安装元数据

软件包元数据

软件包键	brew:pgformatter
版本	5.11
软件包管理器	Homebrew
软件包管理器页面	https://formulae.brew.sh/formula/pgformatter
主页	https://sqlformat.darold.net/
仓库	https://github.com/darold/pgFormatter
上游文档	https://sqlformat.darold.net/
许可证	PostgreSQL
源码归档	https://github.com/darold/pgFormatter/archive/refs/tags/v5.11.tar.gz
最后更新	2026-09-13T11:25:12Z
Pulse	updated
Bottle	可用 (于 arm64_golden_gate, arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, x86_64_linux)
Homebrew post-install	未定义
服务	未声明

注册表事实

源数据库详情

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

源数据库匹配

其他软件包管理器记录

匹配项来自外部软件包管理器索引，并与本地 Automic Vault 软件包链接分开显示。

Debian apt95%

pgformatter 5.6-1

PostgreSQL SQL syntax beautifier

https://sqlformat.darold.net/

sudo apt install pgformatter

Section: database
Architecture: all
1 依赖
normalized package name match
匹配方式：Pgformatter

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

Nix95%

pgformatter

nix profile install nixpkgs#pgformatter

normalized package name match
匹配方式：Pgformatter

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

Ubuntu apt95%

pgformatter 5.5-1

PostgreSQL SQL syntax beautifier

https://sqlformat.darold.net/

sudo apt install pgformatter

Section: universe/database
Architecture: all
1 依赖
normalized package name match
匹配方式：Pgformatter

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

pacman95%

pgformatter 5.10-1

A PostgreSQL SQL syntax beautifier

https://github.com/darold/pgformatter

sudo pacman -S pgformatter

License: PostgreSQL
Architecture: any
1 依赖
normalized package name match
匹配方式：Pgformatter

Arch Linux sync databases · geo.mirror.pkgbuild.com · Arch Linux sync databases: pgformatter from https://geo.mirror.pkgbuild.com/extra/os/x86_64/extra.db.tar.gz

MacPorts95%

pgFormatter

sudo port install pgFormatter

normalized package name match
匹配方式：Pgformatter

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

来源线索

由仓库数据生成

此页面由 av-web 从 scripts/generate-pkg-sqlite.py 生成的私有软件包 SQLite 工件提供。

Combined YAML source

View the package source record on GitHub.

combined/pgformatter.yml

使用的来源

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