commonweb=> DELETE FROM colony_buildings;
DELETE 0
commonweb=> SELECT DISTINCT colonyid FROM colony_buildings;
 colonyid
----------
    17450
    17613
    25527
    25581
(4 rows)