Postgres

PostgreSQL on macOS

Install PostgreSQL using brew brew install postgresql List services maintained by brew $ brew se...

Backslash commands

  command Toggle expanded display \x Toggle tuples only \t Connect to database \c db_name List da...

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...

Dump / Restore

Dump All Functions (to a file) SELECT pg_get_functiondef(f.oid) FROM pg_catalog.pg_proc f INNER J...

Major Version Upgrade on Debian

make a snapshot/backup of the machine check the running clusters using pg_lsclusters command ...