- Learning PostgreSQL 11
- Salahaldin Juba Andrey Volkov
- 180字
- 2021-07-02 13:11:50
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 role. This can be done as follows:
CREATE SCHEMA car_portal_app AUTHORIZATION car_portal_app;
The schema owner is the same as the schema name, if not provided:
CREATE SCHEMA AUTHORIZATION car_portal_app;
For more information about the syntax of the CREATE SCHEMA command, you can use the psql \h meta-command, which displays the psql client tool's inline help, or take a look at the PostgreSQL manual at http://www.postgresql.org/docs/current/static/sql-createschema.html.
推薦閱讀
- 機器學習系統:設計和實現
- 測試驅動開發:入門、實戰與進階
- Learning Chef
- Protocol-Oriented Programming with Swift
- 零基礎趣學C語言
- PHP編程基礎與實例教程
- 第一行代碼 C語言(視頻講解版)
- Mastering Unity 2D Game Development(Second Edition)
- Python趣味編程與精彩實例
- Python Projects for Kids
- MongoDB Administrator’s Guide
- 面向對象分析與設計(第3版)
- Learning Azure DocumentDB
- Python自動化運維:技術與最佳實踐
- OpenStack Networking Cookbook