List of commands for managing and using PostgreSQL.
psql commands are quite forgettable and I forget them a lot, that is why I decided to arrange them into a cheat sheet for reference.
This cheat sheet is divided into sections:
- Installation and config see: Basics
- User/Role setup: Queries
- Commands inside the
psqlshell or backslash(\) commands: PSQL Commands - Dumping, restoring, and managing DBs from your shell/terminal: Terminal Commands
- Utilities
- How to fix some weird errors like: dyld, invalid byte sequence, etc: Troubleshooting
- Advanced
This work is licensed under a Creative Commons Attribution 4.0 International License