testing=# \d com_meter Table "public.com_meter" Column | Type | Modifiers -----------------+-----------------------------+----------- did | integer | timestamp | timestamp without time zone | demand_int | integer | curr_demand | double precision | max_demand | double precision | max_demand_time | timestamp without time zone | units | integer | readings | double precision | Indexes: "com_meter_did_key" UNIQUE, btree (did, "timestamp") Triggers: check_com_meter BEFORE INSERT ON com_meter FOR EACH ROW EXECUTE PROCEDURE check_com_meter() testing=#