GS_LOGICAL_CLASS
GS_LOGICAL_CLASS records information about database objects required for logical decoding and the relationships between the database objects.
| Column | Type | Description |
|---|---|---|
| relname | name | Table name. |
| relnamespace | oid | Namespace OID. |
| relpersistence | "char" | Catalog durability (for example, p indicates a permanent table). |
| relkind | "char" | Table type (for example, r indicates a relationship). |
| relnatts | smallint | Number of columns in the table. |
| relhaspkey | bool | Specifies whether the table has (or has ever had) a primary key index. |
| relcmprs | tinyint | Compression attribute of a row in a table. |
| relreplident | "char" | Replica identity replication mode. |
| spacenode | oid | Tablespace OID. |
| dbnode | oid | Database OID. |
| relnode | oid | Identifier of the physical storage file corresponding to the table. |
| 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. |
| originid | integer | Source identifier of a tuple. |
| relid | oid | Relationship identifier (table OID). |
| relowner | oid | Identifier of the table owner. |
| reltoastrelid | oid | OID of the TOAST table (if any). |
| relhasoids | boolean | Specifies whether the table has an OID column. |
| relam | oid | Identifier that indicates the indexing method used by the table. |
| reloptions | text[] | Additional options for saving the table, stored in text format. |
| relbucket | oid | Identifier of the hash partitioning bucket to which the table belongs. |
| parttype | "char" | Specifies whether the table is a partitioned table. p indicates that the table is a partitioned table, and n indicates that the table is not a partitioned table. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
