Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-3.x)/ Development and Design Proposal/ Database Programming Specifications/ Object Access Programming Specifications

Updated on 2025-08-19 GMT+08:00

View PDF

Object Access Programming Specifications

[Rule] When operating an object, a user should have operation permissions on the object.
For details about the permission description, see Users and Permissions and comply with Permission Design Specifications.
[Rule] Use schemaname.tablename to access objects (such as tables and functions).
If the schema name prefix is not added, the system searches all tablespaces in the current search_path until a matched table is found, which causes unnecessary performance overhead.

Parent topic: Database Programming Specifications

Previous topic: GUC Parameter Programming Specifications

Next topic: WHERE

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.

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