PostgreSQL

postgresql

The world's most advanced open source relational database.

Runs as psql, pg_dump, pg_dumpall, pg_restore, pg_isready, pgbench, createdb, dropdb|macOS, Linux, Windows|www.postgresql.org

Open form in Otty otty.toml

Command form

ai-draft · 3 tasks · 15 fields

Connect with psql and optionally run a command or script file. The other PostgreSQL tools (pg_dump, pg_restore, createdb and so on) are not covered, and passwords are left to the prompt.

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

Run in Otty

otty gui postgresql

psql sessionExample values, fixed in this page — nothing here reaches a terminal

Basic

Host

string

Port

integer

Username

string

Database*

string

TasksEach one presets the form for one job

Connect

hostportusernamedbname

Run a query

hostportusernamedbnamecommandcsvtuples_only

Run a script

hostportusernamedbnamefilesingle_transaction

ParametersOnly these flags are editable in the form

Host

string

--host-h

Port

integer

--port-p

Username

string

--username-U

Database

string

--dbname-d

SQL command

string · repeatable

--command-c

Script file

path

--file-f

List databases

boolean

--list-l

Tuples only

boolean

--tuples-only-t

Unaligned output

boolean

--no-align-A

CSV output

boolean

--csv

Expanded output

boolean

--expanded-x

Quiet

boolean

--quiet-q

Ignore psqlrc

boolean

--no-psqlrc-X

Single transaction

boolean

--single-transaction-1

Never prompt for password

boolean

--no-password-w

SourcesEvery flag above is checked against these

fig

completion

github.com

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