Skip to content

Instantly share code, notes, and snippets.

View giobaski's full-sized avatar

giobaski

  • Superhands
  • Tallinn, Estonia
  • 11:35 (UTC +02:00)
View GitHub Profile
@giobaski
giobaski / postgres-cheatsheet.md
Created July 16, 2019 13:59 — forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet

PSQL

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)
@giobaski
giobaski / sublime-text-3-windows-shortcuts.md
Created October 15, 2017 15:23 — forked from mrliptontea/sublime-text-3-windows-shortcuts.md
Sublime Text 3 - Useful Shortcuts (Windows)

Sublime Text 3 - Useful Shortcuts (Windows)

General

Shortcut Description
Ctrl+Shift+P command prompt
Ctrl+Alt+P switch project
Ctrl+P go to file
Ctrl+G go to line