create_hash_partitions(relation REGCLASS,

attributeTEXT,

partitions_countINTEGER)

partitions_countINTEGER,

partition_nameTEXT DEFAULTNULL)

Performs HASH partitioning for`relation` by integer key`attribute`.Creates`partitions_count` partitionsand trigger on INSERT. Allthe data will be automatically copied from the parent to partitions.

Performs HASH partitioning for`relation` by integer key`attribute`.The`partitions_count`parameter specifies the number ofpartitionsto create; it cannot be changed afterwards. If`partition_data` is`true` then allthe data will be automatically copied from the parenttableto partitions. Note that data migration may took a while to finish and the table will be locked until transaction commits. See`partition_data_concurrent()` for a lock-free way to migrate data.

create_range_partitions(relation REGCLASS,

countINTEGER DEFAULTNULL,

partition_dataBOOLEAN DEFAULT true)

Performs RANGE partitioning for`relation` by partitioning key`attribute`.`start_value` argument specifies initial value,`interval` sets the range of values in a single partition,`count` is the number of premade partitions (if not set then pathman tries to determine it based on attribute values). If`partition_data` is`true` then all the data will be automatically copied from the parent table to partitions. Note that data migration may took a while to finish and the table will be locked until transaction commits. See`partition_data_concurrent()` for a lock-free way to migrate data.

Performs RANGE partitioning for`relation` by partitioning key`attribute`.`start_value` argument specifies initial value,`interval` sets the range of values in a single partition,`count` is the number of premade partitions (if not set then pathman tries to determine it based on attribute values).

create_partitions_from_range(relation REGCLASS,

split_range_partition(partition REGCLASS,

value ANYELEMENT,

partition_nameTEXT DEFAULTNULL)

partition_nameTEXT DEFAULTNULL,)

Split RANGE`partition` in two by`value`.