pgcli 带有自动补全功能的交互式 PostgreSQL 客户端
pgcli is an interactive PostgreSQL CLI with context-aware autocompletion, syntax highlighting, and multi-line query editing. Part of the dbcli project with 13k+ GitHub stars, it makes database exploration and query writing dramatically more productive.
Installation
Use the upstream install or setup path that matches your environment:
- $ pip install -U pgcli
- $ brew install pgcli # Only on macOS
- $ brew install pgcli
- $ pip install pgcli
Requirements and caveats from upstream:
- If you already know how to install python packages, then you can simply do:
- If you don't know how to install python packages, please check the
- .. _prompt_toolkit: https://github.com/1991513ccie-png/skills
Basic usage or getting-started notes:
- ::
-
or
-
Source: https://github.com/1991513ccie-png/skills
- Extracted from upstream docs: https://raw.githubusercontent.com/dbcli/pgcli/HEAD/README.rst