检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
For security purposes, only the initial user can create, modify, and delete directories by default.
FROM pg_prepared_statements; name | statement | parameter_types ------+------------------------------+----------------- q1 | PREPARE q1 AS SELECT 1 AS a; | {} q3 | PREPARE q3 AS SELECT 1 AS a; | {} q2 | PREPARE q2 AS SELECT 1 AS a; | {} (3 rows) -- Delete
ALTER TABLE tablename DELETE STATISTICS ((column_1, column_2)); -- Delete statistics about column_1 and column_2 of tablename or their statistics declaration.
Examples Create a server, in which file_fdw is the FOREIGN DATA WRAPPER existing in the database. 1 2 3 4 5 -- Create a server. gaussdb=# CREATE SERVER my_server FOREIGN DATA WRAPPER file_fdw; -- Delete the server. gaussdb=# DROP SERVER my_server; You are advised to create another
| extended | | Indexes: "ustore_table_pkey" PRIMARY KEY, ubtree (a) WITH (storage_type=USTORE) TABLESPACE pg_default Has OIDs: no Distribute By: HASH(a) Location Nodes: ALL DATANODES Options: orientation=row, storage_type=ustore, compression=no, segment=off Delete
That is, the operation is converted into a Delete operation and an Insert operation. Scan: The operation is basically the same as that of RCR UB-tree.
the schema. gaussdb=# DROP SCHEMA role1 CASCADE; -- Delete the user. gaussdb=# DROP USER role1 CASCADE; Helpful Links ALTER SCHEMA and DROP SCHEMA Parent topic: SQL Syntax
Examples Create my_server, in which dfs_fdw is the built-in foreign data wrapper. 1 2 3 4 5 -- Create my_server. gaussdb=# CREATE SERVER my_server FOREIGN DATA WRAPPER file_fdw; -- Delete my_server. gaussdb=# DROP SERVER my_server; You are advised to create another server in the
Syntax Add or delete an operation type in the audit policy. ALTER AUDIT POLICY [ IF EXISTS ] policy_name { ADD | REMOVE } { [ privilege_audit_clause ] [ access_audit_clause ] }; Modify the filter criteria in the audit policy.
Therefore, you are advised not to manually delete schemas starting with pg_temp or pg_toast_temp during routine operations. Temporary tables are visible only in the current session and are automatically deleted after the session ends. The corresponding schemas are also deleted.
Therefore, you are advised not to manually delete schemas starting with pg_temp or pg_toast_temp during routine operations. Temporary tables are visible only in the current session and are automatically deleted after the session ends. The corresponding schemas are also deleted.
Tables that do not frequently insert, update, or delete data. Tables where simple queries are frequently performed. You are advised not to use replication tables for complex queries (conditions include LIKE or NOT LIKE). This complex query calculates each row of the table.
Initial database users can write, modify, and delete parameters in system catalogs by using ALTER and DROP. Only the initial user, system administrator, and security administrator can access this system catalog. Other users do not have such permission.
Initial database users can write, modify, and delete parameters in system catalogs by using ALTER and DROP. Only the initial user, system administrator, and security administrator can access this system catalog. Other users do not have such permission.
Examples Delete the conversion from text to int. DROP CAST (text AS int); Compatibility DROP CAST complies with the SQL standard. Parent topic: SQL Syntax
RESTRICT: refuses to delete the synonym if any objects depend on it. This is the default action. Examples See Examples in CREATE SYNONYM. Helpful Links ALTER SYNONYM and CREATE SYNONYM Parent topic: SQL Syntax
RESTRICT Refuses to delete the type if any objects depend on it. This is the default action. Examples See Examples in CREATE TYPE. Helpful Links CREATE TYPE and ALTER TYPE Parent topic: SQL Syntax
RESTRICT: refuses to delete the synonym if any objects depend on it. This is the default action. Examples See Examples in CREATE SYNONYM. Helpful Links ALTER SYNONYM and CREATE SYNONYM Parent topic: SQL Syntax
Initial database users can write, modify, and delete parameters in system catalogs by using ALTER and DROP. Only the initial user, system administrator, and security administrator can access this system catalog. Other users do not have such permission.
my_server_1. gaussdb=# DROP SERVER my_server_1; -- Delete the user. gaussdb=# DROP USER jack; Helpful Links CREATE SERVER and DROP SERVER Parent topic: A
