pgcli <database_name or db_url>

No description

Arguments

NameDescription
database_name or db_url

Options

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