Updated on 2024-05-07 GMT+08:00

PG_DIRECTORY

PG_DIRECTORY stores directory objects added by users. You can execute the CREATE DIRECTORY statement to add records to this system catalog. When enable_access_server_directory is set to off, only the initial user can create directory objects. When enable_access_server_directory is set to on, users with the SYSADMIN permission and users inheriting the built-in role permission gs_role_directory_create can create directory objects. Common users can access this system catalog only after being authorized.

Table 1 PG_DIRECTORY columns

Name

Type

Description

oid

oid

Row identifier (hidden attribute, which must be specified)

dirname

name

Name of a directory object

owner

oid

Owner of a directory object

dirpath

text

Directory path.

diracl

aclitem[]

Access permissions.