Set up a trigger on insert to check for the existence of the partition table, then it could do the insert there or create the 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@xxxxxxxxx> 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, i know 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
