Reference

pgcli(1)

CLI for PostgreSQL with auto-completion and syntax highlighting

NAME

pgcli - CLI for PostgreSQL with auto-completion and syntax highlighting

SYNOPSIS

pgcli [OPTIONS] [DATABASE] [USERNAME]

DESCRIPTION

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

SEE ALSO

litecli(1)

mycli(1)
iredis(1)

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.

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

History

--pgclirc since Debian 12 (Bookworm).