Postgres Pro
Downloads
Home   >   mailing lists

Trigger to create automated range partition table - Mailing list pgsql-admin

From bhanu prabhakar
Subject Trigger to create automated range partition table
Date
Msg-id CACBZq4xNCVEsCSnV_vhOQULtcwUnHpji+=eyw2sE2=_2V2n3Mg@mail.gmail.com
Whole thread Raw
Responses Re: Trigger to create automated range partition table
List pgsql-admin
Tree view
Hi friends,

As a part of migration from Oracle to AWS Aurora postgress. I have converted the partition table using ora2pg tool. 

In Oracle we have feature of automated partition table creation when we insert the data, but in postgress 10.4 that feature is not enabled. 

Kindly help me and give some rough idea or example to create  a trigger on table to create automated partition table when we insert the data.Thank you 

Bhanu P Murari.

pgsql-admin by date:

Previous
From: Erwin Fritz
Date:
Subject: RE: Oracle to Postgres-Licensed GUI tool
Next
From: Srinivas Reddy
Date:
Subject: Error while upgrading from 9.5 to 10