使用 Homebrew, Nix 安装 psql2csv

项目链接

• 主页
• 软件包管理器页面

命令和别名

• psql2csv

项目历史

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.

采用历史

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.

使用方式

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.

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

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.

时间线

• 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.

来源

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