Top
Enterprise Postgres 17 SP1 Operation Guide

B.2 Transparent Data Encryption Control Functions

The following table lists the functions that can be used for transparent data encryption.

Table B.2 Transparent data encryption control functions

Name

Return type

Description

pgx_open_keystore(user pin | passphrase)

pgx_open_keystore(sslpassphrase => text)

void

Opens the keystore

pgx_set_master_key(user pin | passphrase)

void

Sets the master encryption key

pgx_declare_external_master_key(kms_name => text, key_id => text, sslpassphrase => text)

void

To set an encryption key existing in a key management system as a master encryption key for transparent data encryption.

pgx_set_keystore_passphrase(oldPassphrase, newPassphrase)

void

Changes the keystore passphrase