Scroll to navigation

PGCLI(1) DBCLI PGCLI(1)

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

Host address of the postgres database.

Port number at which the postgres instance is listening.

User name to connect to the postgres database.

Force password prompt.

Never prompt for password.

Version of pgcli.

Database name to connect to.

Location of pgclirc file.

Show this message and exit.

EXAMPLES

$ pgcli local_database

$ pgcli postgres://amjith:passw0rd@example.com:5432/app_db
$ pgcli -h localhost -p 5432 -U amjith app_db

SEE ALSO

litecli(1)

mycli(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 <amjith.r@gmail.com>.

3.1.0 pgcli