wget like cURL

Use curl like wget:
alias cget='curl -LOR --insecure'
cget https://foo.bar.com/file.tar.xz

PostgreSQL CSV Like Output

Use -t (--tuples-only), -A (--no-align) and -F (--field-separator) to generate CSV like output, e.g.:
psql postgres -tAF, -c'select name, abbrev from pg_timezone_names'

Microphone to Speakers

On the fly playing of captured microphone sound:
arecord | aplay

Colors in grep

Enable color output for grep using an environment variable or on demand:
export GREP_OPTIONS='--color=auto'
grep --color=auto foo bar

Screen Ultimate Attach

Screen Quick Reference: Attaches to a screen session. If the session is attached elsewhere, detaches that other display. If no session exists, creates one. If multiple sessions exist, uses the first one:
screen -dRR