检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
To delete it, switch to another schema first.
This command can only delete the metadata of key objects recorded in the system catalog of the database, but cannot delete the key entities managed by the client key tool or online key service.
If command is set to DELETE, only tuple data that meets the condition (the return value of using_expression is TRUE) can be deleted. The operations that are affected include DELETE and DELETE ... RETURNING.
When separation of duties is disabled, a system administrator has the permission to delete the specified table by default.
There are three scenarios: COORDINATOR: Delete the idle or invalid connections from the current CN to a specified CN. NODE: Delete the idle or invalid connections from the current CN to a specified DN.
the audit policy adt2. gaussdb=#DROP AUDIT POLICY adt2; -- Delete the tb_for_audit table. gaussdb=#DROP TABLE tb_for_audit; -- Delete the dev_audit user. gaussdb=#DROP USER dev_audit; Create an audit policy to audit only the SELECT, INSERT, and DELETE operations performed on the
the audit policy adt2. m_db=# DROP AUDIT POLICY adt2; -- Delete the tb_for_audit table. m_db=# DROP TABLE tb_for_audit; -- Delete the dev_audit user. m_db=# DROP USER dev_audit; Create an audit policy to audit only the SELECT, INSERT, and DELETE operations performed on the adt_lb0
the audit policy adt2. m_db=# DROP AUDIT POLICY adt2; -- Delete the tb_for_audit table. m_db=# DROP TABLE tb_for_audit; -- Delete the dev_audit user. m_db=# DROP USER dev_audit; Create an audit policy to audit only the SELECT, INSERT, and DELETE operations performed on the adt_lb0
Values are INSERT, UPDATE, DELETE, and TRUNCATE. Multiple events can be specified using OR.
RESTRICT: refuses to delete the schema if the schema contains objects. This is the default action. Schemas beginning with pg_temp or pg_toast_temp are for internal use. Do not delete them. Otherwise, unexpected consequences may be incurred.
RESTRICT Refuses to delete the sequence if any objects depend on it. This is the default action.
RESTRICT Refuses to delete the sequence if any objects depend on it. This is the default value.
statements (unit: μs). max_delete_elapse bigint Maximum response time of DELETE statements (unit: μs). min_delete_elapse bigint Minimum response time of DELETE statements (unit: μs). avg_delete_elapse bigint Average response time of DELETE statements (unit: μs).
statements (unit: μs). max_delete_elapse bigint Maximum response time of DELETE statements (unit: μs). min_delete_elapse bigint Minimum response time of DELETE statements (unit: μs). avg_delete_elapse bigint Average response time of DELETE statements (unit: μs).
RESTRICT: refuses to delete the server if any objects depend on it. This is the default action.
RESTRICT Refuses to delete the sequence if any objects depend on it. This is the default action.
RESTRICT Refuses to delete the sequence if any objects depend on it. This is the default action.
RESTRICT Refuses to delete the sequence if any objects depend on it. This is the default action.
If command is set to DELETE, only tuple data that meets the condition (the return value of using_expression is TRUE) can be deleted. The operations that are affected include DELETE and DELETE ... RETURNING.
EXEC SQL INSERT INTO foo VALUES (5, 'abc'); Delete a row. EXEC SQL DELETE FROM foo WHERE a = 5; Update table data. EXEC SQL UPDATE foo SET b = 'gdp' WHERE a = 7; Query data in a single row.
