Shreyas Sreenath Mavanoor shreyasmav

25 | MS Cybersecurity @GeorgiaTech @sppgatech 🐝 🎓 | ex-@PwCUS @StanfordUIT | ATL🍑SFO🌉BLR🏰 | YouTuber @_buildspace n&w s5 irl

shreyasmav / mongodb_cheat_sheet.md

Created November 18, 2019 12:23 — forked from bradtraversy/mongodb_cheat_sheet.md

MongoDB Cheat Sheet

Show All Databases

show dbs

shreyasmav / postgres-cheatsheet.md

Created October 11, 2019 18:15 — forked from Kartones/postgres-cheatsheet.md

PostgreSQL command line cheatsheet

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)