Install in one step.

Pure SQL from one source of truth: psql -f the file, or paste it into any SQL editor. Everything needs only pg_cron. (A Trusted Language Extension package is available too, for completeness.)

Latest release: v0.3.0

Recommended · any Postgres 15–18

Run the SQL: psql or editor

One self-contained file, wrapped in BEGIN; … COMMIT;, no metacommands. psql -f the download, or paste it into the Supabase SQL editor.

Download

Preview SQL

Loading…

Optional · managed Postgres with pg_tle

Trusted Language Extension (database.dev)

For completeness, if you standardize on create extension: on Supabase or any Postgres with pg_tle, install straight from the registry and run it in the SQL editor.

select dbdev.install('dventimisupabase@pg_partition_magician');
create extension "dventimisupabase@pg_partition_magician"
  version '0.3.0' cascade;

Uninstall

Removes the tool, not your data. Drops the pgpm schema and unschedules its pgpm_* cron jobs. Tables you transmuted stay partitioned; their rows are untouched.

Uninstall

Remove pg_partition_magician

Run in the SQL editor or via psql -f. If you installed it as a TLE, drop extension "dventimisupabase@pg_partition_magician" does the same.

Download

Preview SQL

Loading…