I am using Redhat open shift container and Postgres version 15.2. I wish to convert the normal table into a partitioning table. Please help me with the pre-requisite, each and every step to partition. As far as i know, we can create a new partition(parent and child table) and simply insert data from the old table into the new table and drop the old one. Is that all?
Please provide me detailed answer with detailed steps.