Skip to content

Instantly share code, notes, and snippets.

View betrcode's full-sized avatar
👋

Max Wenzin betrcode

👋
View GitHub Profile
@Kartones
Kartones / postgres-cheatsheet.md
Last active May 11, 2024 17:14
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)
@bryanhunter
bryanhunter / build-erlang-r14b04.sh
Created December 1, 2011 17:14
Script to build Erlang 14B04 (tested on a fresh Ubuntu 11.10 install)
#!/bin/bash
# Pull this file dowm, make it executable and run it with sudo
# wget https://raw.github.com/gist/1418287/build-erlang-r14b04.sh
# chmod u+x build-erlang-r14b04.sh
# sudo ./build-erlang-r14b04.sh
if [ $(id -u) != "0" ]; then
echo "You must be the superuser to run this script" >&2
exit 1
fi