Postgresql 中文操作指南

37.1. The Schema #

信息模式本身是一个名为 information_schema 的模式。此模式自动存在于所有数据库中。此模式所有者是群集中的初始数据库用户，并且该用户自然具有对此模式的所有权限，包括删除它的权限（但所节省的空间非常小）。

The information schema itself is a schema named information_schema. This schema automatically exists in all databases. The owner of this schema is the initial database user in the cluster, and that user naturally has all the privileges on this schema, including the ability to drop it (but the space savings achieved by that are minuscule).

默认情况下，信息模式不在模式搜索路径中，因此您需要通过限定名称访问其中的所有对象。由于信息模式中一些对象的名称是可能出现在用户应用程序中的一般名称，因此如果您想将信息模式放在路径中，则应该小心。

By default, the information schema is not in the schema search path, so you need to access all objects in it through qualified names. Since the names of some of the objects in the information schema are generic names that might occur in user applications, you should be careful if you want to put the information schema in the path.