此报错原因为Data not a multiple of block size 是加密后的密文和密钥不配导致的
创建表和插入数据
TEST=#CREATE TABLE T_SEC_SJJM03(c1 VARCHAR(200));
TEST=# INSERT INTO T SEC SJJMO3 VALUES(encrypt( 'data',' fooz','bf' ));
INSERT 0 1
TEST三#select C1, convert from(decrypt('C1' ::bytea,'foozrty' ,'bf' ),'SQL ASCII') from T SEC SJJM03:
错误:decrypt error: Data not a multiple of block size
TEST=#select C1,convert from(decrypt(C1 ::bytea,'fooz','bf' ),'SOL ASCII') from T SEC SJJMO3:
C1 | CONVERT FROM
\x0697f9d2e0652f8a | data