Updated on 2025-02-27 GMT+08:00

GS_LABELS

GS_LABELS displays all configured resource labels. Only the users with the SYSADMIN or POLADMIN permission can access this view.

Table 1 GS_LABELS columns

Name

Type

Description

labelname

name

Resource label name.

labeltype

name

Resource label type. This column corresponds to the labeltype column in the GS_POLICY_LABEL system catalog.

fqdntype

name

Database resource type Such as table, schema, and index.

schemaname

name

Name of the schema to which the database resource belongs.

fqdnname

name

Database resource name.

columnname

name

Name of the database resource column. If the marked database resource is not a column, this parameter is left blank.