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. |
