# Install pgformatter with Homebrew, apt, Nix, pacman, MacPorts

PostgreSQL syntax beautifier. Version 5.10 via Homebrew; verified 2026-05-09. Also installable with debian: sudo apt install pgformatter.

## 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
- **Version:** 5.10
- **Source summary:** PostgreSQL syntax beautifier
- **Homepage:** <https://sqlformat.darold.net/>
- **Repository:** <https://github.com/darold/pgFormatter>
- **Last updated:** 2026-05-09T07:01:22Z
- **Generated:** 2026-08-03T19:37:03+00:00

## Executables

- pg_format (alias)

## Install behavior

- Bottle: not available

## Freshness

- Page generated: 2026-08-03
- Package-manager version: 5.10

## Security Notes

No matching local secret-handling manifest was found for pgformatter. Nucleus package metadata is still published here so future coverage has a stable package URL.


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


## Combined YAML source

View the package source record on GitHub. [combined/pgformatter.yml](https://github.com/mxcl/pkgdb/blob/main/combined/pgformatter.yml)


## Sources

- pkg.so package database
- Geiger risk classifier
- pkgdb category and tag curation
- external package-manager database matches
- cross-ecosystem install command graph