-U names the role, -d the database, and -h 127.0.0.1 forces a TCP connection rather than the Unix socket, exercising pg_hba.conf host rules and password authentication. psql prompts for the password. Add -p 5433 for a non-default port.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.