检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Functions and Operators Text Search Functions and Operators JSON/JSONB Functions and Operators HLL Functions and Operators SEQUENCE Functions Array Functions and Operators Range Functions and Operators Aggregate Functions Window Functions Security Functions Ledger Database Functions Encrypted
The value is NULL. encrypted character varying(3) Not supported. The value is NULL. compress_for character varying(30) Not supported. The value is NULL. def_inmemory character varying(8) Not supported. The value is NULL. def_inmemory_priority character varying(8) Not supported.
Value range: 0, 1, 2, or 3 0 indicates that passwords are encrypted with MD5. 1 indicates that passwords are encrypted with SHA-256 and MD5. 2 indicates that passwords are encrypted with SHA-256. 3 indicates that the passwords are encrypted in sm3 mode.
Unit: none Value range: 0, 1, 2, or 3 0 indicates that passwords are encrypted with MD5. 1 indicates that passwords are encrypted with SHA-256 and MD5. 2 indicates that passwords are encrypted with SHA-256. 3 indicates that the passwords are encrypted with SM3.
Table 1 SQL statements for defining a CMK Function SQL Statement Creating a CMK CREATE CLIENT MASTER KEY Deleting a CMK DROP CLIENT MASTER KEY Defining a CEK CEKs are used to encrypt data for the encrypted database feature.
Its value is NULL. encrypted character varying(3) Not supported. Its value is NULL. compress_for character varying(30) Not supported. Its value is NULL. def_inmemory character varying(8) Not supported. Its value is NULL. def_inmemory_priority character varying(8) Not supported.
Its value is NULL. encrypted character varying(3) Not supported. Its value is NULL. compress_for character varying(30) Not supported. Its value is NULL. def_inmemory character varying(8) Not supported. Its value is NULL. def_inmemory_priority character varying(8) Not supported.
Default value: postgresql enable_ce Specifies the encrypted equality query capability. Property type: integer Value range: 1: JDBC supports the basic capability of encrypted equality query. Other values: The basic capability of encrypted equality query is not supported.
User passwords are encrypted and stored in the system catalog PG_USER_MAPPING. During the encryption, usermapping.key.cipher and usermapping.key.rand are used as the encryption password file and encryption factor.
Syntax CREATE GROUP group_name [ [ WITH ] option [ ... ] ] [ ENCRYPTED | UNENCRYPTED ] { PASSWORD | IDENTIFIED BY } { 'password' [ EXPIRED ] | DISABLE }; The syntax of the option clause (optional) is as follows: {SYSADMIN | NOSYSADMIN} | {MONADMIN | NOMONADMIN} | {OPRADMIN
User passwords are encrypted and stored in the system catalog PG_USER_MAPPING. During the encryption, usermapping.key.cipher and usermapping.key.rand are used as the encryption password file and encryption factor.
Syntax 1 2 CREATE GROUP group_name [ [ WITH ] option [ ... ] ] [ ENCRYPTED | UNENCRYPTED ] { PASSWORD | IDENTIFIED BY } { 'password' [ EXPIRED ] | DISABLE }; The syntax of the option clause (optional) is as follows: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Default value: postgresql enable_ce Specifies the encrypted equality query capability. Property type: integer Value range: 1: JDBC supports the basic capability of encrypted equality query. Other values: The basic capability of encrypted equality query is not supported.
Parameter type: integer Unit: none Value range: 0, 1, 2, or 3 0 indicates that passwords are encrypted with MD5. 1 indicates that passwords are encrypted with SHA-256 and MD5. 2 indicates that passwords are encrypted with SHA-256. 3 indicates that the passwords are encrypted with
whether the role has the system administrator permission. t (true): yes f (false): no rolconnlimit integer Maximum number of concurrent connections that this role can make (valid for roles that can log in) The value –1 indicates there is no limit. rolpassword text Password (possibly encrypted
The value –1 indicates no limit. rolpassword text N/A Encrypted user password.
User passwords are encrypted and stored in the system catalog PG_USER_MAPPING. During the encryption, usermapping.key.cipher and usermapping.key.rand are used as the encryption password file and encryption factor.
The value –1 indicates no limit. rolpassword text N/A Encrypted user password. The value is displayed as ********. rolvalidbegin timestamp with time zone N/A Account validity start time.
User passwords are encrypted and stored in the system catalog PG_USER_MAPPING. During the encryption, usermapping.key.cipher and usermapping.key.rand are used as the encryption password file and encryption factor.
The value –1 indicates no limit. rolpassword text N/A Encrypted user password.
