rendered paste bodytesting=# \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=#