pgcli(1)

pgcli1

Cli for postgresql with auto-completion and syntax highlighting

Usage

pgcli [OPTIONS] [DATABASE] [USERNAME]

Overview

pgcli is a command line interface for PostgreSQL with auto-completion and syntax highlighting. It is also capable of pretty printing tabular data.

Options

-h|--host TEXT

Host address of the postgres database.

-p|--port INTEGER

Port number at which the postgres instance is listening.

-U|--user TEXT

User name to connect to the postgres database.

-W|--password

Force password prompt.

-w|--no-password

Never prompt for password.

-v|--version

Version of pgcli.

-d|--dbname TEXT

Database name to connect to.

--pgclirc TEXT

Location of pgclirc file.

--help

Show this message and exit.

Examples

$ pgcli local_database

$ pgcli postgres://amjith:[email protected]:5432/app_db
$ pgcli -h localhost -p 5432 -U amjith app_db

Homepage

More information about pgcli and the DBCLI project can be found on the homepage at https://www.pgcli.com and https://www.dbcli.com.

Releases

4 releases since Debian 9 (Stretch); the text changed 1 time.

  1. 9–10
  2. 12–13

--pgclirc since Debian 12 (Bookworm).

Authors

pgcli was written by Amjith Ramanujam <[email protected]>.

This manual page was written by Lennart Weller <[email protected]>, for the Debian project (but may be used by others).

From pgcli 4.3.0-2 in Debian 13 (Trixie). Parsed by carta from the page's man source.