Creating Partition from GUI

To add a partition to a partitioned PostgreSQL table, open that table, switch to the Partitions page of the Table window, and click Add button.

Adding a table partition in Database Tour

Creating Partition Options

Partition nameSpecify a name for the partition. In PostgreSQL, a partition is a separate table, so name the partition according to the table naming rules.
Partition expressionSpecify the partition expression.
Partition byIf the new table must be partitioned (i.e. have sub-partitions), specify the PARTITION BY clause, for example, RANGE (<expression>).
DescriptionSpecify the table description (optional).
Additional commandsSpecify additional SQL commands to be executed, for example, adding table constraints and/or indexes.
ActionSpecify either to add the partition and apply additional commands immediately or generate SQL code instead. In latter case, you are able to modify the generated SQL code before applying the commands.

Creating Partition by SQL

Advanced users can also create a table partition by executing SQL query like this (read your database documentation for details):

CREATE TABLE <table_name> PARTITION OF <parent_table_name> FOR VALUES <expression>

See also

 Adding or Modifying Table Field

 Adding Table Index

 Adding Table Constraint

 Adding Table Foreign Key

 Viewing and Editing Table Structure