Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Detailed schema information:

Code Block
languagetext
cpstemporaldb=# \d network_data
                      Table "public.network_data"
   Column   |           Type           | Collation | Nullable | Default
------------+--------------------------+-----------+----------+---------
 timestamp  | timestamp with time zone |           | not null |
 dataspace  | character varying(255)   |           | not null |
 schema_set | character varying(255)   |           | not null |
 anchor     | character varying(255)   |           | not null |
 payload    | jsonb                    |           | not null |
 version    | timestamp with time zone |           | not null |

Indexes:
    "network_data_dataspace_schema_set_anchor_timestamp_idx" UNIQUE, btree (dataspace, schema_set, anchor, "timestamp" DESC)
    "network_data_payload_idx" gin (payload)
    "network_data_timestamp_idx" btree ("timestamp" DESC)


cpstemporaldb=# SELECT * FROM timescaledb_information.dimensions;
 hypertable_schema | hypertable_name | dimension_number | column_name |       column_type        | dimension_type | time_interval | integer_interval | integer_now_func | num_partitions
-------------------+-----------------+------------------+-------------+--------------------------+----------------+---------------+------------------+------------------+----------------
 public            | network_data    |                1 | timestamp   | timestamp with time zone | Time           | 1 day         |                  |                  |
(1 row)

...