Help Center> Data Warehouse Service> Developer Guide> System Catalogs and System Views> System Catalogs> PGXC_GROUP
View PDF

PGXC_GROUP

PGXC_GROUP records information about node groups.

Table 1 PGXC_GROUP columns

Name

Type

Description

group_name

name

Name of the node group

in_redistribution

"char"

Whether redistribution is required

  • n indicates that the Node Group is not redistributed.
  • y indicates the source Node Group in redistribution.
  • t indicates the destination Node Group in redistribution.

group_members

oidvector_extend

Node OID list of the node group

group_buckets

text

Distributed data bucket group

is_installation

Boolean

Whether to install a sub-cluster

group_acl

aclitem[]

Access permissions

group_kind

"char"

Node Group type

  • i indicates an installation Node Group.
  • n indicates a Node Group in a common, non-logical cluster.
  • v indicates a Node Group in a logical cluster.
  • e indicates an elastic cluster.
Parent topic: System Catalogs