This is a quick showoff presentation on the basics of using Postgres and the psql command-line tool, meant for people who are somewhat familiar with MySQL. It doesn't dive terribly deep.
You probably just want to view the presentation, though if you wanted to enhance it you could clone the repo.
For a deeper dive, you might like to check out:
- Coderholic's nifty table comparing PostgreSQL and MySQL commands
- This postgresql.org wiki page on moving to PostgreSQL. It's quite dated (from 2001), but it's mostly accurate, except for the bits about MySQL not having views, etc.
- Wikibook page on converting from MySQL to PostgrSQL, which has a rather extensive table comparing different queries.