ALTER RESOURCE LABEL

Function

ALTER RESOURCE LABEL modifies resource labels.

Precautions

Only user poladmin, user sysadmin, 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.
postgres=# CREATE TABLE table_for_label(col1 int, col2 text);

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

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

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

Helpful Links

CREATE RESOURCE LABEL and DROP RESOURCE LABEL