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