Skip to content

Instantly share code, notes, and snippets.

View bonniss's full-sized avatar
🥐
Cancer - Croissant

Dan Teddy bonniss

🥐
Cancer - Croissant
View GitHub Profile
@bonniss
bonniss / my-psql-common.md
Last active August 13, 2022 21:19
PSQL Common Lines

Installation

Chocolatey

choco install postgresql13 --params '/Password:159753 /Port:5432'
psql -Upostgres
ALTER USER postgres WITH PASSWORD 'new_password';
@bonniss
bonniss / postgres-cheatsheet.md
Created April 12, 2019 07:00 — 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)

Moving from jQuery

Events

// jQuery
$(document).ready(function() {
  // code
})