Help Center> GaussDB> Distributed_8.x> System Catalogs and System Views> System Views> Other System Views> ADM_SOURCE

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

View PDF

ADM_SOURCE

ADM_SOURCE displays the definition information about all stored procedures, functions, and triggers 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 the PG_CATALOG and SYS schemas.

**Table 1** ADM_SOURCE columns
Name	Type	Description
owner	name	Object owner.
name	name	Object name.
type	name	Object type. Its 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. The value is 0.

Parent topic: Other System Views

Previous topic: ADM_SEQUENCES

Next topic: ADM_SYNONYMS

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.