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 permissions of the built-in role gs_role_directory_create can create directory objects.

**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.