PGXC_CLASS
PGXC_CLASS records replicated or distributed information for each table. PGXC_CLASS can only be used to query table definitions in centralized mode.
Name |
Type |
Description |
---|---|---|
pcrelid |
oid |
Table OID |
pclocatortype |
"char" |
Locator type
|
pchashalgorithm |
smallint |
Distributed tuple using the hash algorithm
|
pchashbuckets |
smallint |
Value of a hash container |
pgroup |
name |
Name of the node |
redistributed |
"char" |
Indicates that a table has been redistributed. |
redis_order |
integer |
Redistribution sequence. Tables whose values are 0 will not be redistributed in this round of redistribution. |
pcattnum |
int2vector |
Column number used as a distributed key |
nodeoids |
oidvector_extend |
List of distributed table node OIDs |
options |
text |
Extension status information. This is a reserved column in the system. |
diskey |
text |
Not supported. Its value is NULL. |
diskeyexprs |
pg_node_tree |
Not supported. Its value is NULL. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.