Psql idioms
Jump to navigation
Jump to search
Postgres idioms to save you time
Curators only
cleanup note after load:
update note set sub_id_fk=replacement_fk from retired where sub_id_fk=old_id;
Sysadmins only
SELECT * from pg_stat_activity ; SELECT * from pg_stat_activity where state = 'active'; pg_cancel_backend(pid int) to kill