Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ System Catalogs and System Views/ System Catalogs/ Logical Decoding/ GS_LOGICAL_ENUM

Updated on 2025-05-29 GMT+08:00

View PDF

GS_LOGICAL_ENUM

GS_LOGICAL_ENUM contains entries showing the values and labels for each enumerated type.

**Table 1** GS_LOGICAL_ENUM columns
Column	Type	Description
enumid	oid	Row identifier.
enumtypid	oid	OID of the PG_TYPE entry owning this enumerated value.
enumlabel	name	Textual label for this enumerated value.
enumsortorder	real	Sort position of this enumerated value within its enumerated type.
dbnode	oid	Database OID.
originid	integer	Source identifier of a tuple.
createtime	timestamp with time zone	Timestamp when a tuple is inserted.
csnmin	bigint	CSN when a tuple is inserted.
csnmax	bigint	CSN when a tuple is updated or deleted.

Parent topic: Logical Decoding

Previous topic: GS_LOGICAL_SET

Next topic: Multi-Tenant Databases

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.