Psql idioms: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 7: | Line 7: | ||
update note set sub_id_fk=replacement_fk from retired where sub_id_fk=old_id; | update note set sub_id_fk=replacement_fk from retired where sub_id_fk=old_id; | ||
select max(ecfp4_fk) from fingerprints.ecfp4_data | |||
= Sysadmins only = | = Sysadmins only = |
Revision as of 20:23, 4 November 2014
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;
select max(ecfp4_fk) from fingerprints.ecfp4_data
Sysadmins only
SELECT * from pg_stat_activity ; SELECT * from pg_stat_activity where state = 'active'; pg_cancel_backend(pid int) to kill