# Install pgformatter

PostgreSQL syntax beautifier. Version 5.10 via Homebrew; verified 2026-05-09.

## Install

```sh
sudo av install brew:pgformatter
```

Additional install commands:

### macOS

- Homebrew (100%):

```sh
brew install pgformatter
```

  Evidence: local Homebrew formula metadata

- MacPorts (94%):

```sh
sudo port install pgFormatter
```

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

### Linux

- Debian apt (92%):

```sh
sudo apt install pgformatter
```

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

- Nix (92%):

```sh
nix profile install nixpkgs#pgformatter
```

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

- pacman (92%):

```sh
sudo pacman -S pgformatter
```

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

## Package Facts

- **Package key:** brew:pgformatter
- **Package manager:** Homebrew
- **Package manager URL:** <https://formulae.brew.sh/formula/pgformatter>
- **Version:** 5.10
- **Source summary:** PostgreSQL syntax beautifier
- **Homepage:** <https://sqlformat.darold.net/>
- **Repository:** <https://github.com/darold/pgFormatter>
- **Upstream docs:** <https://github.com/darold/pgFormatter#readme>
- **License:** PostgreSQL
- **Source archive:** <https://github.com/darold/pgFormatter/archive/refs/tags/v5.10.tar.gz>
- **Last updated:** 2026-05-09T07:01:22Z
- **Generated:** 2026-06-10T07:18:26+00:00

## Executables

- pg_format (cli)
- pg_format (alias)

## Install Behavior

- Post-install hook: not defined
- Bottle: available on all

## Freshness

- Page generated: 2026-06-10
- Package-manager version: 5.10
- Package-manager updated: 2026-05-09
- Local data status: ok
- Upstream repository: https://github.com/darold/pgFormatter
- Upstream latest detected: v5.10 (current)

## Sicherheitshinweise

no executable entrypoint in the package index.

- **Geiger risk:** green / low
- no executable entrypoint in the package index

## Source Database Details

- **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

## Other Package-Manager Records

- Debian apt - pgformatter - 5.6-1: normalized package name match | Debian stable package indexes: pgformatter from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | PostgreSQL SQL syntax beautifier | https://sqlformat.darold.net/
- Nix - pgformatter: normalized package name match | nixpkgs package indexes: pkgs/by-name/pg/pgformatter/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1
- Ubuntu apt - pgformatter - 5.5-1: normalized package name match | Ubuntu 24.04 LTS package indexes: pgformatter from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | PostgreSQL SQL syntax beautifier | https://sqlformat.darold.net/
- pacman - pgformatter - 5.10-1: normalized package name match | Arch Linux sync databases: pgformatter from https://geo.mirror.pkgbuild.com/extra/os/x86_64/extra.db.tar.gz | A PostgreSQL SQL syntax beautifier | https://github.com/darold/pgformatter
- MacPorts - pgFormatter: normalized package name match | MacPorts ports tree: databases/pgFormatter/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1


## Related Links

- [Terminal utility packages](https://www.automicvault.com/de/pkg/terminal-utilities/) - Matched terminal and command-line workflow metadata.
- [Text processing packages](https://www.automicvault.com/de/pkg/text-processing-tools/) - Matched text, document, or structured-data processing metadata.
- [Developer build packages](https://www.automicvault.com/de/pkg/developer-build-tools/) - Matched build, compiler, generator, or developer workflow metadata.
- [Networking and protocol packages](https://www.automicvault.com/de/pkg/networking-protocol-tools/) - Matched network, protocol, or remote-service metadata.
- [dbmate](https://www.automicvault.com/de/pkg/brew/dbmate/) - Shares av.db curated category or tags: cli, database, developer-tools, postgresql, sql.
- [pg-schema-diff](https://www.automicvault.com/de/pkg/brew/pg-schema-diff/) - Shares av.db curated category or tags: cli, database, developer-tools, postgresql, sql.
- [sqlbench](https://www.automicvault.com/de/pkg/brew/sqlbench/) - Shares av.db curated category or tags: cli, database, developer-tools, postgresql, sql.
- [pgdbf](https://www.automicvault.com/de/pkg/brew/pgdbf/) - Shares av.db curated category or tags: cli, command-line-tool, database, developer-tools, postgresql.
- [libpq](https://www.automicvault.com/de/pkg/brew/libpq/) - Shares av.db curated category or tags: cli, database, developer-tools, postgresql.
- [supabase](https://www.automicvault.com/de/pkg/brew/supabase/) - Shares av.db curated category or tags: cli, database, developer-tools, postgresql.
- [yamlfmt](https://www.automicvault.com/de/pkg/brew/yamlfmt/) - Shares av.db curated category or tags: cli, developer-tools, formatter.
- [pgcli](https://www.automicvault.com/de/pkg/brew/pgcli/) - Shares av.db curated category or tags: cli, database, developer-tools, postgresql.

## Sources

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