Renaming a Partition in Greenplum

Partitioned tables are created using the naming convention:  <parentname>_<level>_prt_<partition_name>
For example:

sales_1_prt_jan08
Or for auto-generated range partitions (a number is assigned when no name is given):
sales_1_prt_1

It is not possible to rename a partitioned child table directly by altering the table name. However, you can rename the top-level parent table, and the associated <parentname> will change in the table names of all associated child table partitions. For example:

ALTER TABLE sales RENAME TO globalsales;
Would change the associated table names accordingly: 
globalsales_1_prt_1

You can also change the partition name of a partition to make it easier to identify. For example:
ALTER TABLE sales RENAME PARTITION FOR ('2008-01-01') TO jan08;
Would change the associated table name accordingly:
sales_1_prt_jan08

When altering partitioned tables with the ALTER TABLE command, they are always referred to by their partition name (jan08) and not their full table name (sales_1_prt_jan08).
Comments