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