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

DB_SOURCE

DB_SOURCE displays the definition information about stored procedures, functions, triggers, and packages 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. 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.