Updated on 2024-05-07 GMT+08:00

DB_SOURCE

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

Table 1 DB_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 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.