Updated on 2024-06-03 GMT+08:00

DB_DIRECTORIES

DB_DIRECTORIES is used to view all directories on which the current user has the operation permission. Administrators can query all directories, and common users can query only directories on which the current user has the operation permission. This view exists in both PG_CATALOG and SYS schema.

Table 1 DB_DIRECTORIES columns

Name

Type

Description

owner

oid

OID of the owner of a directory object.

directory_name

name

Name of a directory object.

directory_path

text

Directory path represented by a directory object.

origin_con_id

character varying(256)

ID of the container where a directory object is created.

Not supported. Its value is NULL.