Re: [ADMIN] Partitions

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