ALTER RESOURCE LABEL

Function

ALTER RESOURCE LABEL modifies resource labels.

Precautions

Only users with the poladmin or sysadmin permission, or the initial user can perform this operation.

Syntax

ALTER RESOURCE LABEL label_name (ADD|REMOVE) 
  label_item_list[, ...]*;

• label_item_list

  resource_type(resource_path[, ...]*)
  

• resource_type

  TABLE | COLUMN | SCHEMA | VIEW | FUNCTION
  

Parameter Description

• label_name

  Specifies the resource label name.

  Value range: a string. It must comply with the naming convention.

• resource_type

  Specifies the type of database resources to be labeled.

• resource_path

  Specifies the path of database resources.

Examples

-- Create basic table table_for_label.
openGauss=# CREATE TABLE table_for_label(col1 int, col2 text);

-- Create resource label table_label.
openGauss=# CREATE RESOURCE LABEL table_label ADD COLUMN(table_for_label.col1);

-- Attach resource label table_label to col2.
openGauss=# ALTER RESOURCE LABEL table_label ADD COLUMN(table_for_label.col2)

-- Remove table_label from an item.
openGauss=# ALTER RESOURCE LABEL table_label REMOVE COLUMN(table_for_label.col1);

Helpful Links

CREATE RESOURCE LABEL and DROP RESOURCE LABEL