Available Columns

    Sample Usage

    1. CREATE TABLE hyper_2dim (a_col date, b_col timestamp, c_col integer);
    2. SELECT table_name from create_hypertable('hyper_2dim', 'a_col');
    3. SELECT add_dimension('hyper_2dim', 'b_col', chunk_time_interval=> '7 days');
    5. SELECT * FROM timescaledb_information.dimensions WHERE hypertable_name = 'hyper_2dim';
    7. -[ RECORD 1 ]-----+----------------------------
    8. hypertable_name   | hyper_2dim
    9. dimension_number  | 1
    10. column_name       | a_col
    11. column_type       | date
    13. time_interval     | 7 days
    14. integer_interval  | 
    15. integer_now_func  | 
    16. num_partitions    | 
    17. hypertable_schema | public
    18. hypertable_name   | hyper_2dim
    19. dimension_number  | 2
    20. column_name       | b_col
    21. column_type       | timestamp without time zone
    22. dimension_type    | Time
    23. time_interval     | 7 days
    24. integer_interval  |