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