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

ADM_SOURCE

ADM_SOURCE displays the definition information about all stored procedures, functions, triggers, and packages 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_SOURCE columns

Name

Type

Description

owner

name

Object owner.

name

name

Object name.

type

name

Object type. Its values can be function, package, package body, procedure, and trigger.

line

numeric

Number of the line in the definition information.

text

text

Text source of the storage object.

origin_con_id

character varying(256)

Not supported. Its value is 0.