All pastes #11461 Raw Edit

Mine

public text v1 · immutable
#11461 ·published 2005-05-11 03:54 UTC
rendered paste body
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=#