INSERT INTO testuserscards(username, cc)SELECT robotccs.username, pgp_pub_encrypt(robotccs.cc, keys.pubkey) As cc FROM (VALUES ('robby', '41111111111111111'), ('artoo', '41111111111111112') ) As robotccs(username, cc) CROSS JOIN (SELECT dearmor('-----BEGIN PGP PUBLIC KEY BLOCK----- super publickey goobly gook goes here -----END PGP PUBLIC KEY BLOCK-----') As pubkey) As keys;
Can you simplify that to the simplest case which shows the problem? Probably just the 'select dearmor(...)'.
It doesn't like something about your public key. Since you censored that data, there isn't much we can say about what specifically it did not like.