Extended Functions
For the extended data, GaussDB(DWS) provides corresponding operation functions. The operation function depends on the extension data type. Currently, in the Beta stage, functions may not stable or versions may later change. Use these functions with caution in commercial service scenarios. Otherwise, the service upgrade and scale-out may be affected.
The following table lists the extended functions supported by GaussDB(DWS) and they are for reference only.
| Type | Name | Description |
|---|---|---|
| Access privilege inquiry function | has_sequence_privilege(user, sequence, privilege) | Queries whether a specified user has privilege for sequences. |
| has_sequence_privilege(sequence, privilege) | Queries whether the current user has privilege for sequences. | |
| Trigger function | pg_get_triggerdef(trigger_oid) | Gets CREATE [ CONSTRAINT ] TRIGGER command for triggers. |
| pg_get_triggerdef(trigger_oid, pretty_bool) | Gets CREATE [ CONSTRAINT ] TRIGGER command for triggers. |
Last Article: GIN Tips and Tricks
Next Article: Extended Syntax
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.