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

MY_SOURCE

MY_SOURCE displays the definition information about stored procedures, functions, and triggers accessible to the current user. This view exists in the PG_CATALOG and SYS schemas.

Table 1 MY_SOURCE columns

Name

Type

Description

owner

name

Object owner.

name

name

Object name.

type

name

Object type. The value can be function, procedure, or trigger.

line

numeric

Number of the source line.

text

text

Text source of the storage object.

origin_con_id

character varying(256)

Not supported. Set it to 0.