Help Center > > Developer Guide> System Catalogs and System Views> System Catalogs> PGXC_CLASS

PGXC_CLASS

Updated at: Jul 15, 2020 GMT+08:00

PGXC_CLASS records the replicated or distributed information for each table.

Table 1 PGXC_CLASS columns

Name

Type

Description

pcrelid

oid

OID of the table

pclocatortype

"char"

Locator type

  • H: hash
  • M: Modulo
  • N: Round Robin
  • R: Replicate

pchashalgorithm

smallint

Distributed tuple using the hash algorithm

pchashbuckets

smallint

Value of a harsh container

pgroup

name

Name of a node cluster

redistributed

"char"

Indicates that a table has been redistributed.

redis_order

integer

Redistribution sequence

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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel