pentabarf_bsdcan=> SELECT routine_name FROM information_schema.routines WHERE routine_schema IN ('public','auth') GROUP BY routine_name HAVING count(routine_name) > 1;
     routine_name
-----------------------
 pgp_pub_decrypt
 digest
 pgp_sym_decrypt
 pgp_pub_encrypt
 pgp_pub_decrypt_bytea
 pgp_pub_encrypt_bytea
 hmac
 pgp_sym_encrypt_bytea
 gen_salt
 pgp_sym_decrypt_bytea
 pgp_sym_encrypt
(11 rows)

pentabarf_bsdcan=>