testcontainers-java

1
-- Extend the database with TimescaleDB
2
CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;
3

4
CREATE TABLE bar
5
(
6
    foo  VARCHAR(255),
7
    time TIMESTAMPTZ NOT NULL
8
);
9

10
SELECT create_hypertable('bar', 'time');
11

12
INSERT INTO bar (time, foo)
13
VALUES (CURRENT_TIMESTAMP, 'hello world');
14