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; | ||
= Sysadmins only = | |||
SELECT * from pg_stat_activity ; | |||
SELECT * from pg_stat_activity where state = 'active'; | |||
pg_cancel_backend(pid int) to kill | |||
[[Category:Idioms]] | [[Category:Idioms]] | ||
Revision as of 20:22, 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;
Sysadmins only
SELECT * from pg_stat_activity ; SELECT * from pg_stat_activity where state = 'active'; pg_cancel_backend(pid int) to kill