create_hash_partitions(relation REGCLASS,

attributeTEXT,

partitions_countINTEGER,

partition_nameTEXT DEFAULTNULL,

partition_dataBOOLEAN DEFAULT TRUE)

Performs HASH partitioning for`relation` by integer key`attribute`. The`partitions_count` parameter specifies the number of partitions to create; it cannot be changed afterwards. 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_table_concurrently()` for a lock-free way to migrate data. Partition creation callback is invoked for each partition if set beforehand (see`set_part_init_callback()`).

Performs HASH partitioning for`relation` by integer key`attribute`. The`partitions_count` parameter specifies the number of partitions to create; it cannot be changed afterwards. 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_table_concurrently()` for a lock-free way to migrate data. Partition creation callback is invoked for each partition if set beforehand (see`set_init_callback()`).

create_range_partitions(relation REGCLASS,

Same as above, but for a RANGE-partitioned table.

replace_hash_partition(old_partition REGCLASS,

new_partition REGCLASS,

lock_parent BOOL DEFAULT TRUE)

Replaces specified partition of HASH-partitioned table with another table. The`lock_parent` parameter will prevent any INSERT/UPDATE/ALTER TABLE queries to parent table.

split_range_partition(partition REGCLASS,

split_value ANYELEMENT,