Help Center/ Data Warehouse Service/ Developer Guide/ Developer Guide (9.1.1.x)/ DWS System Catalogs and Views/ System Catalogs/ PG_TDE
Updated on 2026-07-02 GMT+08:00
View PDF
Share

PG_TDE

PG_TDE stores information about TDE keys. This system catalog is supported only by clusters of version 9.1.1.200 or later.

Table 1 PG_TDE columns

Name

Type

Description

encryptalgo

char

Cryptographic algorithm. Two types of algorithms are supported.

  • a: AES algorithm
  • s: SM4 algorithm

dekcipher

text

Data encryption key

cekid

text

Master key (used to encrypt the data encryption key)

Example

1
2
3
4
5
6
 
SELECT * FROM pg_tde;
encryptalgo|                                        dekcipher                                                 |                          cekid 
-----------+--------------------------------------------------------------------------------------------------+----------------------------------------------------------
    a      | a472d0d8f95a4449e4138b2dd39fdacdd516311a9163c912340229a43da092656a994b7bb0e3cee5bc438aafcbb99889 |     fb234337-45b3-4cab-8bfe-0086b983c4c3
    s      | 74937c481f70445f90bb0e1831431353cbb4a3203535bf67432455275d6a93bf531310301f690b5274078114e2431311 |     fb234337-45b3-4cab-8bfe-0086b983c4c3
(2 rows)
Parent Topic: System Catalogs