Miscellaneous Notes

@esql 'SELECT id.value FROM "quantexa-mdm-example-entity-store-business-all-data"' # Elasticsearch

Excel: Open Dropdown in Cell - ALT-DOWN_ARROW

code: ALT+z - Enable word wrap
code: CTRL+, - Open Settings
code: CTRL+. - Fix problem
code: CTRL+; - Find next problem (I added this shortcut)
code: CTRL+k CTRL+s - Open Keyboard Shortcuts

find . -name "*.jar" -exec du -h {} \;
find . -type d -name ".git" # Find directories
find . -type f -mtime +90 # Find files last modified at least 90 days ago

git checkout tags/<tag name> # checkout a git tag.

postgres: ALTER ROLE <username> SET search_path TO <schema name>; # Permanently alter search_path.
postgres: SET search_path TO <schema name>; # Alter the schema searched.
postgres: SHOW search_path; # show the currently search schema.
postgres: export PGPASSWORD=postgres
postgres: export PGPASSWORD=postgres; cat my.sql | psql -h localhost -U postgres -d postgres

psql: SET search_path=<schema>[,<schema>]; # set current schema(s)
psql: SHOW search_path; # show current schema(s)
psql: \c <db> # connect to database
psql: \d <table> # describe table
psql: \dn # list schemas
psql: \dt # list tables
psql: \l # list databases

sort -h # Sort human readable numbers eg 1.2GB, 9KB

tar -cvzf filename sourcedir # Create tarball.
tar -xvzf <filename> # Extract zipped tarball.

tr A-Z a-z - lowercase
tr a-z A-Z - uppercase

wsl: Config /c/Users/[name]/.wslconfig