Summary and Highlights: PostgreSQL总结与要点：PostgreSQL

Congratulations! You have completed this lesson. At this point, you know that:
祝贺您完成了本课程。此时，您已经知道：

• PostgreSQL, known for its reliability and flexibility, is an open-source database system with deployment options including local installation, virtualization, containerization, and cloud services.
  PostgreSQL 以其可靠性和灵活性而闻名，是一个开源的数据库系统，其部署选项包括本地安装、虚拟化、容器化和云服务。
• Connectivity to PostgreSQL databases is facilitated by tools like psql and pgAdmin, as well as commercial options and managed services.
  连接到 PostgreSQL 数据库的工具包括 psql 和 pgAdmin，以及商业选项和托管服务。
• psql serves as the default command-line interface for PostgreSQL interaction, while pgAdmin offers a comprehensive platform featuring a Query Tool and ERD Tool for visual design.
  psql 是 PostgreSQL 交互的默认命令行界面，而 pgAdmin 提供了一个全面的平台，具有查询工具和 ER 图设计工具用于可视化设计。
• Various tools, including psql and pgAdmin, can be used to create PostgreSQL objects.
  各种工具，包括 psql 和 pgAdmin，都可以用来创建 PostgreSQL 对象。
• Database backups and restoration in PostgreSQL can be performed using pg_dump and psql.
  PostgreSQL 中的数据库备份和恢复可以通过 pg_dump 和 psql 来完成。
• The pgAdmin Import/Export tool aids in loading data into tables and exporting data from them.
  pgAdmin 导入/导出工具有助于将数据加载到表中以及从表中导出数据。
• Views, another method of data presentation from one or more tables, can be utilized to restrict access to sensitive data and simplify data retrieval.
  视图，作为从一个或多个表中展示数据的方法，可用于限制对敏感数据的访问并简化数据检索。
• Materialized views store result sets for fast access but do not support insertion, updating, or deletion of rows.
  物化视图存储结果集以实现快速访问，但不支持行的插入、更新或删除。