Kill

Permanently add SSH Key Password to the Keychain ssh-add --apple-use-keychain ~/.ssh/THEPRIVATEKEY Tool for Window Management Install rectangle Install with brew brew install rectangle Useful Shortcuts Move current app to previous or next display Ctrl+Opt+Cmd+LEFT or Ctrl+Opt+Cmd+RIGHT Maximize window Ctrl+Opt+ENTER Beginners List of Shortcuts coming from Linux …​ Finder Show hidden files in Finder: cmd + shift + . Open Finder: Option + Cmd + Space Open Location: Shift + Cmd + G Change to parent dir in Finder: super + UP ...

Get size of a table SELECT pg_size_pretty(pg_total_relation_size('schemaname.tablename')); Select unique combination of fields / tuples SELECT DISTINCT ON(field1, field2) field1, field2 FROM thetable Select rows where a combination of fields is not unique SELECT columnA, columnB, count(*) AS count FROM thetable GROUP BY columnA, columnB HAVING count(*) > 1 Search for rows with array containing value Assuming, the field appointments has the type date[] SELECT * FROM mtable WHERE appointments @> ARRAY['2023-09-19'::date] ...