Skip to content

Instantly share code, notes, and snippets.

View giobaski's full-sized avatar

giobaski

  • Superhands
  • Tallinn, Estonia
  • 05:22 (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
@giobaski
giobaski / index.html
Created February 6, 2017 19:25
My Portfolio
<header>
<link rel="stylesheet" type="text/css" href="//fonts.googleapis.com/css?family=Patua One" />
<link href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css" rel="stylesheet" integrity="sha384-wvfXpqpZZVQGK6TAh5PVlGOfQNHSoD2xbE+QkPxCAFlNEevoEH3Sl0sibVcOQVnN" crossorigin="anonymous">
</header>
<ul class="nav nav-pills navbar-collapse navbar-fixed-top">
<li>
<a href="#page1">George V. Tsipuria</a>
</li>