data_historization

pig build pkg data_historization;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install data_historization;		# install via package name, for the active PG version

pig install data_historization -v 18;   # install for PG 18
pig install data_historization -v 17;   # install for PG 17
pig install data_historization -v 16;   # install for PG 16
pig install data_historization -v 15;   # install for PG 15
pig install data_historization -v 14;   # install for PG 14

CREATE EXTENSION data_historization CASCADE; -- requires plpgsql

SELECT historize_table_init('public', 'my_table');

SELECT historize_table_start('public', 'my_table');

SELECT historize_table_stop('public', 'my_table');

SELECT historize_table_reset('public', 'my_table');

SELECT historize_table_clean('public', 'my_table');

SELECT historize_create_partition('public', 'my_table_log', 0);
SELECT historize_drop_partition('public', 'my_table_log', 0);

SELECT cron.schedule_in_database(
    'create-partitions', '00 08 * * *',
    $$SELECT historize_create_partition('my_table', generate_series(1, 4))$$,
    'my_database'
);