Tag Archives: postgresql table migration to another schema

In this blogpost I will discuss how can you remap database objects you would like to move from one schema to another. The method i will be using is through backup dump: In a database “company_sales”, I have tables under the default “PUBLIC” schema: // I will first create the destination schema: create schema schema1; …

Continue reading “Remap Schema in PostgreSQL”