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

ADM_DIRECTORIES

ADM_DIRECTORIES stores information about 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 the PG_CATALOG and SYS schemas.

Table 1 ADM_DIRECTORIES columns

Name

Type

Description

owner

oid

Directory owner

directory_name

name

Directory name

directory_path

text

Operating system path name of a directory

origin_con_id

character varying(256)

Not supported. Set it to NULL.