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

OS path name of a directory.

origin_con_id

character varying(256)

Not supported. Set it to NULL.