Learning PostgreSQL 11 - Third Edition

Schema usages

Schemas are used for the following reasons:

• Control authorization: In a multi-user database environment, you can use schemas to group objects based on roles.

• Organize database objects: You can organize the database objects in groups based on business logic. For example, historical and auditing data could be logically grouped and organized in a specific schema.
• Maintain third-party SQL code: The extensions available in the contribution package can be used with several applications. Maintaining these extensions in separate schemas enables the developer to reuse these extensions and to update them easily.

In the car web portal, let's assume that we would like to create a schema named car_portal_app, owned by the car_portal_app ...