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; …
Tag Archives: PostgreSQL saudi arabia
PostgreSQL SCHEMA Fundamentals
If you have ever worked in a relational database system before, I am sure you know the concept of a schema. A schema can be described as a “container” for all of your database objects (tables,views,…etc). each database objects will be placed under the specified schema: schema_name.table_name So basically you can have the same exact …
PostgreSQL Certificate
I am the first Saudi National to be certified in PostgreSQL database technology.
PostgreSQL Master 