OptionsOn pgcli itself
-h--host
Host address of the postgres database <text>
-p--port
Port number at which the postgres instance is listening <integer>
-U--username
Username to connect to the postgres database <text>
-u--user
Username to connect to the postgres database <text>
-W--password
Force password prompt
-w--no-password
Never prompt for password
--single-connection
Do not use a separate connection for completions
-v--version
Version of pgcli
-d--dbname
Database name to connect to <text>
--pgclirc
Location of pgclirc file <file>
-D--dsn
Use DSN configured into the [alias_dsn] section of pgclirc file <text>
--list-dsn
List of DSN configured into the [alias_dsn] section of pgclirc file
--row-limit
Set threshold for row limit prompt. Use 0 to disable prompt <integer>
--less-chatty
Skip intro on startup and goodbye on exit
--prompt
Prompt format (Default: "\u@\h:\d> ") <text>
--prompt-dsn
Prompt format for connections using DSN aliases (Default: "\u@\h:\d> ") <text>
-l--list
List available databases, then exit
--auto-vertical-output
Automatically switch to vertical output mode if the result is wider than the terminal width
--warn
Warn before running a destructive query <choice>
--ssh-tunnel
Open an SSH tunnel to the given address and connect to the database from it <text>
--help
Show this message and exit