brew / Rang 2805

pgformatter mit Homebrew, apt, Nix, pacman, MacPorts installieren

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

Installationsbefehl Sicherheitshinweise

Installation

Weitere Installationsbefehle

macOS

Homebrewverifiziert · 100%

brew install pgformatter

local Homebrew formula metadata

MacPortsverifiziert · 94%

sudo port install pgFormatter

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

Linux

Debian aptverifiziert · 92%

sudo apt install pgformatter

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

Nixverifiziert · 92%

nix profile install nixpkgs#pgformatter

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

Arch Linux pacmanverifiziert · 92%

sudo pacman -S pgformatter

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

Überblick

Paketzusammenfassung

PostgreSQL syntax beautifier

Projektlinks

Befehle und Aliase

pg_format

Verlauf

Projektgeschichte und Nutzung

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.

Projektgeschichte

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.

Adoptionsgeschichte

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.

Wie es verwendet wird

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.

Warum Paket-Nerds sich dafür interessieren

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.

Zeitleiste

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.

Quellen

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

Sicherheitslage

Noch keine Protected-Tool-Abdeckung gefunden

Für pgformatter wurde kein passendes lokales Secret-Handling-Manifest gefunden. Paketmetadaten bleiben hier veröffentlicht, damit künftige Abdeckung eine stabile Paket-URL hat.

Installationsverhalten

In den Formelmetadaten ist kein Homebrew-Post-install-Hook erfasst.
Homebrew-Bottle-Metadaten sind für 6 Plattformziele verfügbar.

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

Executables

Installierte Executables

Befehl	Art	Sichtbarkeit	Hinweis
`pg_format`	cli	globales 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-11-04

Manager-Version5.11

Manager aktualisiert2026-09-13

lokale DatenOK

Upstreamaktuell

neueste erkannte Versionv5.11

https://github.com/darold/pgFormatter

OKEs wurden keine Aktualitätswarnungen generiert.

Installationsmetadaten

Paketmetadaten

Paketschlüssel	brew:pgformatter
Version	5.11
Paketmanager	Homebrew
Paketmanager-Seite	https://formulae.brew.sh/formula/pgformatter
Homepage	https://sqlformat.darold.net/
Repository	https://github.com/darold/pgFormatter
Upstream-Dokumentation	https://sqlformat.darold.net/
Lizenz	PostgreSQL
Quellarchiv	https://github.com/darold/pgFormatter/archive/refs/tags/v5.11.tar.gz
Zuletzt aktualisiert	2026-09-13T11:25:12Z
Pulse	updated
Bottle	verfügbar (auf arm64_golden_gate, arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, x86_64_linux)
Homebrew post-install	nicht definiert
Dienst	keiner deklariert

Registry-Fakten

Details aus der Quelldatenbank

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

Source-Datenbank-Treffer

Andere Paketmanager-Einträge

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

Debian apt95%

pgformatter 5.6-1

PostgreSQL SQL syntax beautifier

https://sqlformat.darold.net/

sudo apt install pgformatter

Section: database
Architecture: all
1 Abhängigkeiten
normalized package name match
Abgeglichen nach: 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
Abgeglichen nach: 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 Abhängigkeiten
normalized package name match
Abgeglichen nach: 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 Abhängigkeiten
normalized package name match
Abgeglichen nach: 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
Abgeglichen nach: 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

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.

Combined YAML source

View the package source record on GitHub.

combined/pgformatter.yml

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