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

ADM_DIRECTORIES

ADM_DIRECTORIES displays all directory objects in the database. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schema.

Table 1 ADM_DIRECTORIES columns

Name

Type

Description

owner

oid

Directory owner

directory_name

name

Directory name

directory_path

text

OS path name of a directory.

origin_con_id

character varying(256)

Not supported. Its value is NULL.