Set up a trigger on insert to check for the existence of the partition table, then it could do the insert there or
createthe table if needed and insert. Look online. I know I’ve seen examples of this.
—
Jay
Sent from my iPad
> On Nov 9, 2017, at 6:28 PM, rammohan ganapavarapu <rammohanganap@gmail.com> wrote:
>
> Hi,
>
> I have a requirement to create monthly partitions in my db, i am trying to understand what is the best way to do it,
iknow i can run a cron job to check if partition exist and create if not at the starting of month. Any suggestions?
>
> Thanks,
> Ram
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin