Updated on 2025-07-22 GMT+08:00

MY_SOURCE

MY_SOURCE displays information about stored procedures or functions owned by the current user and provides columns defined by the stored procedures or the functions. This view exists in both PG_CATALOG and SYS schemas.

Table 1 MY_SOURCE columns

Name

Type

Description

owner

character varying(64)

Owner of a stored procedure or function.

name

character varying(64)

Name of a stored procedure or function.

text

text

Definition of a stored procedure or function.