pgcli

A postgres client that does auto-completion and syntax highlighting.

Runs as pgcli|macOS, Linux, Windows|www.pgcli.com

Command form

ai-draft · 2 tasks · 14 fields

Open pgcli against a database, by name, URL or individual connection options. Passwords are never entered here; pgcli prompts for them.

Opens the form; the finished command lands at your prompt, unrun

Run in Otty

otty gui pgcli

Connect to PostgreSQLExample values, fixed in this page — nothing here reaches a terminal

Basic

Database name or URL*

string

Host

string

Port

integer

Username

string

Database (option form)

string

Advanced

Force password prompt

--password

Never prompt for password

--no-password

DSN alias

string

List databases and exit

--list

Skip intro and goodbye

--less-chatty

Auto vertical output

--auto-vertical-output

Row limit prompt threshold

integer

Warn on destructive queries

string

pgclirc file

file

TasksEach one presets the form for one job

Connect with URL or name

databasehostportusernamedbnameforce_passwordno_passworddsnlistless_chattyauto_verticalrow_limitwarnpgclirc

Connect to host

hostportusernamedbnameforce_password

ParametersOnly these flags are editable in the form

Database name or URL

string · positional 0

Host

string

--host-h

Port

integer

--port-p

Username

string

--username-U

Database (option form)

string

--dbname-d

Force password prompt

boolean

--password-W

Never prompt for password

boolean

--no-password-w

DSN alias

string

--dsn-D

List databases and exit

boolean

--list-l

Skip intro and goodbye

boolean

--less-chatty

Auto vertical output

boolean

--auto-vertical-output

Row limit prompt threshold

integer

--row-limit

Warn on destructive queries

string

--warnallmoderateoff

pgclirc file

path

--pgclirc

SourcesEvery flag above is checked against these

fig

completion

github.com

Before it fills your prompt, Otty checks the installed pgcli against its version. A form that does not match your version is not offered.