Skip to content

Instantly share code, notes, and snippets.

View mudspringhiker's full-sized avatar
🏛️

Alona Varshal mudspringhiker

🏛️
  • Austin, TX
View GitHub Profile
@heyalexej
heyalexej / pytz-time-zones.py
Created November 16, 2016 09:14
list of pytz time zones
>>> import pytz
>>>
>>> for tz in pytz.all_timezones:
... print tz
...
...
Africa/Abidjan
Africa/Accra
Africa/Addis_Ababa
Africa/Algiers
@Kartones
Kartones / postgres-cheatsheet.md
Last active May 14, 2024 10:48
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)