export (or look otherwise at) the encrypted rows

[gurucubano]

Is there a way to export encrypted rows in encrypted form, or look at them in this form. This is only for investigation on the strength of the encryption.

[dAdAbird]

Hi @gurucubano
You can use pageinspct to look at the tuples' data: https://www.postgresql.org/docs/current/pageinspect.html#PAGEINSPECT-HEAP-FUNCS
For example:

CREATE EXTENSION pageinspect;
SELECT t_data FROM heap_page_items(get_raw_page('your_table_name', 0));