Hi, list. Just found out you can customize the psql prompt.
For example:
\set PROMPT1 '%n(at)%/ on %`hostname` (%M:%>) %# '
Tells you db user, db name, server hostname,
and the IP address and port that the db server
listens on, plus the prompt (regular or superuser).
If you like it, put it in your ~/.psqlrc
You can go fancy with colors, etc.
Reference: http://www.postgresql.org/docs/8.4/interactive/app-psql.html
Best,
-at