CREATE TABLE range_rel (

id SERIAL PRIMARY KEY,

dt TIMESTAMP,

txt TEXT);

INSERT INTO range_rel (dt, txt)

SELECT g, md5(g::TEXT) FROM generate_series('2015-01-01', '2015-04-30', '1 day'::interval) as g;

set ora_func_style = false;

SELECT create_range_partitions('RANGE_REL', 'DT', '2015-01-01'::DATE, '1 month'::INTERVAL);

 CREATE_RANGE_PARTITIONS

-------------------------

                       4

(1 row)

TEST=# \d+ RANGE_REL;

                                                       Table "PUBLIC.RANGE_REL"

 Column |            Type             |                       Modifiers                        | Storage  | Stats target | Description

--------+-----------------------------+--------------------------------------------------------+----------+--------------+------------

-

 ID     | INTEGER                     | not null default NEXTVAL('RANGE_REL_ID_SEQ'::REGCLASS) | plain    |              |

 DT     | TIMESTAMP WITHOUT TIME ZONE |                                                        | plain    |              |

 TXT    | TEXT                        |                                                        | extended |              |

Indexes:

    "RANGE_REL_PKEY" PRIMARY KEY, BTREE (ID)

Child tables: RANGE_REL_1,

              RANGE_REL_2,

              RANGE_REL_3,

              RANGE_REL_4