检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
=# CREATE SECURITY LABEL sec_label2 'L3:G1-G5'; -- View the security labels created in the system. gaussdb=# SELECT * FROM gs_security_label; label_name | label_content ------------+--------------- sec_label | L1:G4 sec_label1 | L1:G2,G4 sec_label2 | L3:G1-G5 (3 rows) -- Delete
Delete: The index deletion process is added to the UB-tree. The main procedure of index deletion is similar to that of index insertion. That is, obtain the transaction information, fill in the xmax column, and update active_tuple_count on pages.
ledgernsp | usertable | b3a9ed0755131181 | 328b48c4370faed930937869783c23e0 | update ledgernsp. usertable set name = 'bob2' where id = 2; 2 | testdb | omm | 2021-04-14 07:01:29.896148+08 | 16393 | ledgernsp | usertable | 0ae4b4e4ed2fcab5 | aa8f0a236357cac4e5bc1648a739f2ef | delete
ledgernsp | usertable | b3a9ed0755131181 | 328b48c4370faed930937869783c23e0 | update ledgernsp. usertable set name = 'bob2' where id = 2; 2 | testdb | omm | 2021-04-14 07:01:29.896148+08 | 16393 | ledgernsp | usertable | 0ae4b4e4ed2fcab5 | aa8f0a236357cac4e5bc1648a739f2ef | delete
CALL proc_raw(); -- Delete the stored procedure. DROP PROCEDURE proc_raw; Parent topic: Secondary Encapsulation APIs (Recommended)
ALTER EXTENSION name SET SCHEMA new_schema; Add or delete member objects of the extension.
blob_type_t1 VALUES(10,empty_blob(), HEXTORAW('DEADBEEF'),E'\\xDEADBEEF'); -- Query data in the table. gaussdb=# SELECT * FROM blob_type_t1; bt_col1 | bt_col2 | bt_col3 | bt_col4 ---------+---------+----------+------------ 10 | | DEADBEEF | \xdeadbeef (1 row) -- Delete
on; -- Reset the enable_seqscan parameter for jim. gaussdb=# ALTER USER jim RESET enable_seqscan; -- Lock jim. gaussdb=# ALTER USER jim ACCOUNT LOCK; -- Unlock jim. gaussdb=# ALTER USER jim ACCOUNT UNLOCK; -- Change the username. gaussdb=# ALTER USER jim RENAME TO lisa; -- Delete
You cannot reboot or delete an instance that is being scaled up. Storage space can only be scaled up, not down.
Do not reboot or delete the instance whose storage is being scaled up. Storage space can only be scaled up, not down.
-e -c Before re-creating database objects, clear (delete) the database objects that exist in the database to be imported. -c -s Only schema definitions are imported. Sequence values and data will not be imported.
The following DML statements support synonyms: SELECT, INSERT, UPDATE, DELETE, EXPLAIN, and CALL. You are advised not to create synonyms for temporary tables. To create a synonym, you need to specify the schema name of the target temporary table.
If the UPDATE or DELETE statement uses the WHERE CURRENT OF cursor_name syntax, the query is not pushed down.
A role with the CREATEROLE permission can also modify and delete other roles. Value range: If not specified, NOCREATEROLE is the default.
A role with the CREATEROLE permission can also modify and delete other roles. Value range: If not specified, NOCREATEROLE is the default.
*/ gaussdb=# SELECT * FROM logs_nchar WHERE log_id = RPAD(TRIM('FE306991300002 '),16,' '); log_id | log_message --------+------------- (0 rows) /* Delete the table. */ gaussdb=# DROP TABLE logs_nchar; Compare the bpchar type with the text type (the pkg_bpchar_opc extension
- Perform some INSERT and DELETE operations. SQL> ALTER TABLE employees DEALLOCATE UNUSED; Table altered.
- Perform some INSERT and DELETE operations. SQL> ALTER TABLE employees DEALLOCATE UNUSED; Table altered.
---------------------+----------- user3 | Create DB | {user4} gaussdb=# \du user4 List of roles Role name | Attributes | Member of -----------+-------------------------+----------- user4 | Create DB | {} -- Delete
(4) )DISTRIBUTE BY HASH (CT_COL1); -- Insert data. gaussdb=# INSERT INTO char_type_t1 VALUES ('ok'); -- Query data in the table. gaussdb=# SELECT ct_col1, char_length(ct_col1) FROM char_type_t1; ct_col1 | char_length ---------+------------- ok | 4 (1 row) -- Delete
