CREATE TABLE example (
id BIGSERIAL PRIMARY KEY,
rv_id BIGINT NOT NULL,
uuid VARCHAR(36)
);
INSERT INTO example (rv_id, uuid) (
VALUES (22, 'tom'),
(23, 'angela')
)
RETURNING *;
ALTER TABLE example ADD COLUMN offset_id BIGINT GENERATED ALWAYS AS IDENTITY(SEQUENCE NAME offset_sequence) ;
SELECT setval('offset_sequence', (SELECT EXTRACT(epoch FROM now())+10000000000));