psql2csv mit Homebrew, Nix installieren

Projektlinks

• Homepage
• Paketmanager-Seite

Befehle und Aliase

• psql2csv

Projektgeschichte

Philipe Fatio created psql2csv as a shell-based frontend that runs a PostgreSQL query through psql and emits CSV. The repository's official documentation presents it as a compact command-line utility rather than a separate database client.

Adoptionsgeschichte

The official README documents distribution through Homebrew, while the supplied package metadata also records Nix packaging. Its deliberately small, single-script form also supports manual installation into PATH.

Wie es verwendet wird

A query can be supplied as the final argument or through standard input, with CSV written to standard output. Users can control delimiters, quoting, escaping, NULL representation, headers, encoding, time zone, and search path; remaining arguments are forwarded to psql.

Warum Paket-Nerds sich dafür interessieren

psql2csv exemplifies the Unix package tradition of wrapping a capable lower-level client with a narrowly focused command. It makes scripted PostgreSQL-to-CSV export convenient while preserving access to psql connection and variable options.

Zeitleiste

• Initial project phase: Published as a standalone shell script for psql-to-CSV export.
• Homebrew adoption: The official README documents installation with brew.
• 2019: The README's advanced example documents parameterized recurring-report workflows.

Related projects

• PostgreSQL psql performs the database connection and query work.
• PostgreSQL COPY provides the underlying export semantics documented by the project.

Quellen

• Official project README: https://github.com/fphilipe/psql2csv#readme