Magic words:
psql -U postgresIf run with -E flag, it will describe the underlaying queries of the \ commands (cool for learning!).
Most \d commands support additional param of __schema__.name__ and accept wildcards like *.*
sial-ari
/ postgres-cheatsheet.md
Created
June 2, 2017 08:23
— forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet
sial-ari
/ gist:f96d8485ca783f7d7d54
Last active
September 14, 2015 10:15
— forked from atcuno/gist:3425484ac5cce5298932
HowTo: Privacy & Security Conscious Browsing
The purpose of this document is to make recommendations on how to browse in a privacy and security conscious manner. This information is compiled from a number of sources, which are referenced throughout the document, as well as my own experiences with the described technologies.
I welcome contributions and comments on the information contained. Please see the How to Contribute section for information on contributing your own knowledge.
sial-ari
/ latency.markdown
Last active
August 29, 2015 19:54
— forked from hellerbarde/latency.markdown
Latency numbers every programmer should know
L1 cache reference ......................... 0.5 ns
Branch mispredict ............................ 5 ns
L2 cache reference ........................... 7 ns
Mutex lock/unlock ........................... 25 ns
Main memory reference ...................... 100 ns
Compress 1K bytes with Zippy ............. 3,000 ns = 3 µs
Send 2K bytes over 1 Gbps network ....... 20,000 ns = 20 µs
SSD random read ........................ 150,000 ns = 150 µs
Read 1 MB sequentially from memory ..... 250,000 ns = 250 µs
sial-ari
/ gist:8bc0827ef9b989011e42
Last active
August 29, 2015 14:21
— forked from Spoygg/gist:3122226
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| altwin:menu = +altwin(menu) | |
| altwin:meta_alt = +altwin(meta_alt) | |
| altwin:ctrl_win = +altwin(ctrl_win) | |
| altwin:meta_win = +altwin(meta_win) | |
| altwin:left_meta_win = +altwin(left_meta_win) | |
| altwin:super_win = +altwin(super_win) | |
| altwin:hyper_win = +altwin(hyper_win) | |
| altwin:alt_super_win = +altwin(alt_super_win) | |
| altwin:swap_lalt_lwin = +altwin(swap_lalt_lwin) | |
| grp:switch = +group(switch) |