检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
You can add, delete, edit and move a column. Change the partition sequence according to the requirements in the table. To change the order, select the required partition and click Up or Down. After defining all partitions, click Next.
Grant the usage permission of myschema to user jack. 1 GRANT USAGE ON schema myschema TO jack; Run the following command to revoke the USAGE permission for myschema from jack: 1 REVOKE USAGE ON schema myschema FROM jack; Drop Schema Run the DROP SCHEMA command to delete an empty
CALL func_return(); 1 -- Delete the function: DROP FUNCTION func_return; Parent Topic: GaussDB(DWS) Stored Procedure
To use EXPLAIN ANALYZE on an INSERT, UPDATE, DELETE, CREATE TABLE AS, or EXECUTE statement without letting the command affect your data, use this approach: 1 2 3 START TRANSACTION; EXPLAIN ANALYZE ...; ROLLBACK; Syntax Display the execution plan of an SQL statement, which supports
Grant the usage permission of myschema to user jack. 1 GRANT USAGE ON schema myschema TO jack; Run the following command to revoke the USAGE permission for myschema from jack: 1 REVOKE USAGE ON schema myschema FROM jack; Drop Schema Run the DROP SCHEMA command to delete an empty
CALL func_return(); 1 -- Delete the function: DROP FUNCTION func_return; Parent Topic: GaussDB(DWS) Stored Procedure
If one of your CNs is abnormal, you can only delete this abnormal CN. If two or more CNs are abnormal, you can delete CNs only after the CNs are recovered from faults. Managing resource load Resources cannot be managed during offline scale-out.
[Proposal] To clear all data in a table, you are advised to use TRUNCATE TABLE instead of DELETE TABLE. DELETE TABLE is not efficient and cannot release disk space occupied by the deleted data. Type conversion [Proposal] Perform type coercion to convert data types.
If you call it, the following message is displayed: "ERROR: For security purposes, it is not allowed to manually delete audit logs." 1 2 SELECT * FROM pg_delete_audit('2023-01-10 17:00:00','2023-01-10 19:00:00'); ERROR: For security purposes, it is not allowed to manually delete
[Proposal] To clear all data in a table, you are advised to use TRUNCATE TABLE instead of DELETE TABLE. DELETE TABLE is not efficient and cannot release disk space occupied by the deleted data. Type conversion [Proposal] Perform type coercion to convert data types.
Deleting an Automated Snapshot Only GaussDB(DWS) can delete automated snapshots; you cannot delete them manually. When the retention period of an automated snapshot ends or a cluster is deleted, GaussDB(DWS) deletes the automated snapshot.
Deleting the masking policy of a table The DROP REDACTION POLICY syntax is used to delete the masking function information of a masking policy on all columns of a table.
Deleting the masking policy of a table The DROP REDACTION POLICY syntax is used to delete the masking function information of a masking policy on all columns of a table.
Select cascade if you want to delete the object. GAUSS-01796: "role %u was concurrently dropped" SQLSTATE: 42704 Description: The object needs to be locked before the system records dependency relationships of tables.
Delete the imported OID item or add an OID column to the user table. GAUSS-01205: "COPY (SELECT) WITH OIDS is not supported" SQLSTATE: 0A000 Description: COPY WITH OIDs is not supported. Solution: Do not use COPY WITH OIDs.
ta.table_schema and dtp.table_name = ta.table_name) where ta.table_schema = 'public'; Part of the execution plan is as follows: In the system view, the OR condition is used for permission check. 1 pg_has_role(c.relowner, 'USAGE'::text) OR has_table_privilege(c.oid, 'SELECT, INSERT, UPDATE, DELETE
A confirmation dialog box is displayed, asking you whether to delete the database. This operation can be performed on a disconnected database. Viewing Data Properties Right-click the selected database and select Properties.
Click Yes to delete the view. Right-click the selected view and select Drop View Cascade. Parent topic: Database Management
Syntax 1 2 3 4 5 6 7 ALTER BLOCK RULE block_name [ [ TO user_name@'host' ] | [ TO user_name ] | [ TO 'host' ] | [ TO DEFAULT ] ] | [ FOR UPDATE | SELECT | INSERT | DELETE | MERGE | DEFAULT ] | FILTER BY { SQL ( 'text' ) | TEMPLATE ( template_parameter = value ) }
Syntax 1 2 3 4 5 6 CREATE BLOCK RULE [ IF NOT EXISTS ] block_name [ [ TO user_name@'host' ] | [ TO user_name ] | [ TO 'host' ] ] | [ FOR UPDATE | SELECT | INSERT | DELETE | MERGE ] | FILTER BY { SQL ( 'text' ) | TEMPLATE ( template_parameter = value ) } [ WITH
