官术网_书友最值得收藏!

  • 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;
主站蜘蛛池模板: 双牌县| 蓬安县| 常宁市| 延川县| 金堂县| 沂源县| 靖安县| 穆棱市| 阿克| 黎平县| 张北县| 南江县| 建湖县| 邢台市| 东明县| 石柱| 广安市| 临西县| 扶余县| 龙州县| 吉隆县| 原阳县| 宁陕县| 昌图县| 新沂市| 奉化市| 镇安县| 绍兴县| 湘潭市| 忻城县| 南涧| 霞浦县| 抚顺市| 九江市| 中宁县| 凤冈县| 巴彦淖尔市| 卓资县| 兰西县| 包头市| 乐昌市|