Note: With the release of PostgreSQL 11, this tool is mostly not needed.
Partitions may have their own indexes, constraints and default values, distinct from those of other partitions. Indexes must be created separately for each partition.
Postgres Partition Index is a CLI tool to facilitate creating an INDEX across multiple PostgreSQL 10 partitions/tables.
A direct install is provided for macOS, Linux, and OpenBSD:
curl https://raw.githubusercontent.com/joaodlf/pgpi/master/install.sh | sh
Binaries (including Windows) can also be downloaded.
