- Learning PostgreSQL 11
- Salahaldin Juba Andrey Volkov
- 181字
- 2021-07-02 13:11:49
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 the database and the session.
Finally, a database can use several programming languages:

In order to create a database, you need to specify the owner and the encoding of the database; if the encoding of template1 doesn't match the required encoding, template0 should be used explicitly.
For the car-web high-level objects interaction-portal database, let's assume the database owner is the car_portal_role role and the encoding is UTF-8. To create this database on Linux, execute the following commands:
CREATE ROLE car_portal_app 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;
On Windows, the CREATE DATABASE syntax is a bit different due to locale:
CREATE DATABASE car_portal ENCODING 'UTF-8' LC_COLLATE 'English_United States' LC_CTYPE 'English_United States' TEMPLATE template0 OWNER car_portal_app;
- 數(shù)據(jù)庫(kù)程序員面試筆試真題與解析
- SpringMVC+MyBatis快速開發(fā)與項(xiàng)目實(shí)戰(zhàn)
- 深入淺出WPF
- Vue.js入門與商城開發(fā)實(shí)戰(zhàn)
- Learning Data Mining with Python
- 實(shí)用防銹油配方與制備200例
- Windows Server 2012 Unified Remote Access Planning and Deployment
- Access 2016數(shù)據(jù)庫(kù)管
- INSTANT Django 1.5 Application Development Starter
- Learning Unity 2D Game Development by Example
- Visual Studio 2015高級(jí)編程(第6版)
- Building Serverless Architectures
- QGIS 2 Cookbook
- 寫給大家看的Midjourney設(shè)計(jì)書
- NGUI for Unity