Nice intro. One great trick if you want to learn more about the system tables is `psql -e`. This will show the queries used internally by all the \d, \u, etc. commands.