检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 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
'Beijing','China'); -- Query the table data distributed on the dn_6007_6008_6009 node. gaussdb=# EXECUTE DIRECT ON(dn_6007_6008_6009) 'SELECT * FROM tbl_range'; id | name | province | country -----+--------+----------+--------- 300 | Jordan | Beijing | China (1 row) -- Delete
num2; END; / -- Create an operator class and associate it with the preceding function. gaussdb=# CREATE OPERATOR CLASS oc1 DEFAULT FOR TYPE _int4 USING btree AS FUNCTION 1 func_add_sql (integer, integer); -- Drop the operator. gaussdb=# DROP OPERATOR CLASS oc1 USING btree; -- Delete
=# 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
ALTER EXTENSION name SET SCHEMA new_schema; Add or delete member objects of the extension.
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
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
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.
CALL proc_raw(); -- Delete the stored procedure. DROP PROCEDURE proc_raw; Parent topic: Secondary Encapsulation APIs (Recommended)
-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.
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.
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
Value range: enumerated values origin indicates that the system copies operations such as insert, delete, and update from the current session. replica indicates that the system copies operations such as insert, delete, and update from other places to the current session. local indicates
