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

  • 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 high-level object interaction

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;;
主站蜘蛛池模板: 天柱县| 中卫市| 桃源县| 全州县| 南阳市| 慈利县| 邯郸市| 元谋县| 枣阳市| 蕲春县| 曲周县| 奎屯市| 崇仁县| 绥芬河市| 石河子市| 连山| 常宁市| 沿河| 扶绥县| 望都县| 五指山市| 双鸭山市| 重庆市| 汝阳县| 阿克苏市| 耿马| 永定县| 屯昌县| 绥江县| 同心县| 武乡县| 老河口市| 永德县| 武夷山市| 襄樊市| 江源县| 清徐县| 阜新市| 彩票| 香格里拉县| 闽侯县|