Back to list
bash

psql accepts connection strings

psql can accept a full connection URI instead of passing individual flags for host, port, database, and user.

This is especially handy when working with managed database providers (Supabase, Neon, Railway, etc.) since they typically give you a connection string you can copy and paste directly. No more juggling five different flags.

fc -p # commands you run after this won't be saved to your shell history (for current session only)

psql postgres://myuser:mypassword@localhost:5432/mydb
# same as:
psql -h localhost -p 5432 -U myuser -d mydb

fc -P # back to normal
postgresqltool
lubosmato