Help Center/ GaussDB(DWS)/ Developer Guide/ Standard data warehouse (8.1.3.x)/ GaussDB(DWS) System Catalogs and Views/ System Views/ PG_TDE_INFO
Updated on 2024-11-05 GMT+08:00
View PDF
Share

PG_TDE_INFO

PG_TDE_INFO displays the encryption information about the current cluster.

Table 1 PG_TDE_INFO columns

Name

Type

Description

is_encrypt

text

Whether the cluster is an encryption cluster

  • f: Non-encryption cluster
  • t: Encryption cluster

g_tde_algo

text

Encryption algorithm

  • SM4-CTR-128
  • AES-CTR-128

remain

text

Reserved columns

Examples

Check whether the current cluster is encrypted, and check the encryption algorithm (if any) used by the current cluster.

1
2
3
4
5
 
SELECT * FROM PG_TDE_INFO;
 is_encrypt | g_tde_algo  | remain
------------+-------------+--------
 f          | AES-CTR-128 | remain
(1 row)
Parent topic: System Views