sysop@hub:~/cheat-sheets/postgresql-admin-cheat-sheet$

postgresql-admin-cheat-sheet

psql commands start with a backslash, the rest is SQL. On a default Linux install, become the postgres user first: sudo -u postgres psql. mydb and app are placeholder names.