- Learning PostgreSQL
- Salahaldin Juba Achim Vannahme Andrey Volkov
- 163字
- 2021-04-02 20:32:15
PostgreSQL high-level object interaction
To sum up, a PostgreSQL server can contain many databases, programming languages, roles, and tablespaces. Each database has an owner and a default tablespace; a role can be granted permission to access or can own several databases. The settings can be used to control the behavior of the PostgreSQL server on several levels, such as database and session. Finally, a database can use several programming languages:

PostgreSQL main components conceptual relations
In order to create a database, one needs to specify the owner and the encoding of the database; if the encoding of template1
does not match the required encoding, template0
should be used explicitly.
For the car web high level objects interaction portal database, let us assume that the database owner is the car_portal_role
role, and encoding is UTF8. In order to create this database, one can execute the following commands:
CREATE ROLE car_portal_role LOGIN; CREATE DATABASE car_portal ENCODING 'UTF-8' LC_COLLATE 'en_US.UTF-8' LC_CTYPE 'en_US.UTF-8' TEMPLATE template0 OWNER car_portal_app;;
- UI設計基礎培訓教程
- Delphi程序設計基礎:教程、實驗、習題
- 自制編譯器
- Swift 3 New Features
- Visual C++串口通信技術詳解(第2版)
- 教孩子學編程:C++入門圖解
- 正則表達式經典實例(第2版)
- Hands-On Swift 5 Microservices Development
- Python Web數據分析可視化:基于Django框架的開發實戰
- PySpark Cookbook
- Unity 2018 Shaders and Effects Cookbook
- Linux Shell核心編程指南
- TMS320LF240x芯片原理、設計及應用
- Windows Embedded CE 6.0程序設計實戰
- 移動增值應用開發技術導論