Psql idioms

From DISI
Revision as of 20:23, 4 November 2014 by Frodo (talk | contribs)
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;



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
Retrieved from "http://wiki.docking.org/index.php?title=Psql_idioms&oldid=8164"