Windows · Developer Tools
PostgreSQL CLI client
PostgreSQL interactive terminal
Version 18.6.5 · by PostgreSQL Global Development Group
Official site: postgresql.org
About PostgreSQL CLI client
psql is a terminal-based front-end to PostgreSQL. It enables you to type in queries interactively, issue them to PostgreSQL, and see the query results. Alternatively, input can be from a file or from command line arguments. In addition, psql provides a number of meta-commands and various shell-like features to facilitate writing scripts and automating a wide variety of tasks.
This package provides the 64-bit Windows commands `psql`, `pg_dump`, `pg_dumpall`, and `pg_restore`, with their required runtime libraries. It does not install a PostgreSQL server or create a database service.
## Versioned packages
Each supported PostgreSQL major has its own client package, named `psql `. Install and upgrade `psql18` to stay on PostgreSQL 18:
```powershell
choco install psql18
choco upgrade psql18
choco uninstall psql18
```
## Virtual package
The `psql` package depends on the exact corresponding version of `psql `. Its newest release follows the newest supported stable PostgreSQL major; upgrading it can therefore install a new major version.
```powershell
choco install psql
choco upgrade psql
choco uninstall psql --force-dependencies
```
Uninstalling `psql` without `--force-dependencies` removes only the virtual package. A previous major package may remain installed after a major upgrade; uninstall it separately when it is no longer needed.
The client commands use Chocolatey's standard executable shims. If multiple major packages are installed, the command on `PATH` follows the shim most recently installed. Use the executable in the required package's `tools` directory to select a particular major explicitly.
**Please Note**: This is an automatically updated package. If you find it is
out of date by more than a day or two, please contact the maintainer(s) and
How to install PostgreSQL CLI client
- Click Download — the developer's official website opens in a new tab.
- Download the latest version there and run it. Choose Custom/Advanced where offered, and skip any bundled extras.
- Prefer the command line? With Chocolatey you can install and update it with: choco install postgresql-cli-client
- Open PostgreSQL CLI client once it finishes installing.
Frequently asked questions
Is PostgreSQL CLI client free to download?
Yes. The Download button sends you to postgresql.org, the developer's official site, where PostgreSQL CLI client is available to download. Grabware doesn't host or modify any files.
What is the latest version of PostgreSQL CLI client?
The version listed here is 18.6.5, published /Date(1790. The developer's site always has the newest release.
How do I install PostgreSQL CLI client from the command line?
With Chocolatey, run: choco install postgresql-cli-client. This installs it from the official source and keeps it updated.
Is PostgreSQL CLI client safe?
PostgreSQL CLI client downloads directly from the developer. As always, scan the installer with your antivirus and choose Custom setup to skip any bundled extras.
Alternatives to PostgreSQL CLI client
More
March 2014 servicing stack update for Windows 8.1 and Windows Server 2012 R2 (KB2919442)The update fixes some issues in the servicing stack of Windows 8.1 and Windows Server 2012 R2.Chocolatey Compatibility ExtensionExtension package to provide compatibility with older versions of Chocolatey
Update for Universal C Runtime in Windows (KB2999226)Update for Universal C Runtime (CRT) in Windows. Before you install this update, check out the prerequisites section.