Recently Updated Pages
Skoda
Octavia Second Generation (2005-2013) facelift 2009 same platform with Golf Mk5 and Audi A3 Mk2 n...
Hyundai / KIA
i30 Second Generationa (GD) 2012-2017 GDI models and T-GDI are engines with direct injection, T s...
Serato
Keyboard Shortcuts See also https://serato.com/latest/blog/17257/pro-tips-serato-dj-keyboard-shor...
Notes
check Chuck - music programming language Ideas of setup for session view Launchpad (Quneo) should...
Dump / Restore
Dump All Functions (to a file) SELECT pg_get_functiondef(f.oid) FROM pg_catalog.pg_proc f INNER J...
Cheatsheet
Truncate/empty all tables SELECT 'TRUNCATE TABLE ' || tablename || ' CASCADE;' FROM pg_tables WH...
Queries with IPs
Top networks CREATE TABLE ip ( id serial NOT NULL, addr cidr NOT NULL, hostname character v...
Backslash commands
command Toggle expanded display \x Toggle tuples only \t Connect to database \c db_name List da...
PostgreSQL on macOS
Install PostgreSQL using brew brew install postgresql List services maintained by brew $ brew se...