PostgreSQL Cmd-Line Cheatsheet Connect via TCP/IP as a certainuser: psql -U username dbname -h localhost Some useful commands: l - show all databases