|
| 1 | + |
| 2 | +-- drop function digest(bytea, text); |
| 3 | +-- drop function digest_exists(text); |
| 4 | +-- drop function hmac(bytea, bytea, text); |
| 5 | +-- drop function hmac_exists(text); |
| 6 | +-- drop function crypt(text, text); |
| 7 | +-- drop function gen_salt(text); |
| 8 | +-- drop function gen_salt(text, int4); |
| 9 | +-- drop function encrypt(bytea, bytea, text); |
| 10 | +-- drop function decrypt(bytea, bytea, text); |
| 11 | +-- drop function encrypt_iv(bytea, bytea, bytea, text); |
| 12 | +-- drop function decrypt_iv(bytea, bytea, bytea, text); |
| 13 | +-- drop function cipher_exists(text); |
| 14 | + |
| 15 | + |
| 16 | + |
| 17 | +CREATEFUNCTIONdigest(bytea,text) RETURNSbytea |
| 18 | +AS'$libdir/pgcrypto', |
| 19 | +'pg_digest' LANGUAGE'C'; |
| 20 | + |
| 21 | +CREATEFUNCTIONdigest_exists(text) RETURNS bool |
| 22 | +AS'$libdir/pgcrypto', |
| 23 | +'pg_digest_exists' LANGUAGE'C'; |
| 24 | + |
| 25 | +CREATEFUNCTIONhmac(bytea,bytea,text) RETURNSbytea |
| 26 | +AS'$libdir/pgcrypto', |
| 27 | +'pg_hmac' LANGUAGE'C'; |
| 28 | + |
| 29 | +CREATEFUNCTIONhmac_exists(text) RETURNS bool |
| 30 | +AS'$libdir/pgcrypto', |
| 31 | +'pg_hmac_exists' LANGUAGE'C'; |
| 32 | + |
| 33 | +CREATEFUNCTIONcrypt(text,text) RETURNStext |
| 34 | +AS'$libdir/pgcrypto', |
| 35 | +'pg_crypt' LANGUAGE'C'; |
| 36 | + |
| 37 | +CREATEFUNCTIONgen_salt(text) RETURNStext |
| 38 | +AS'$libdir/pgcrypto', |
| 39 | +'pg_gen_salt' LANGUAGE'C'; |
| 40 | + |
| 41 | +CREATEFUNCTIONgen_salt(text, int4) RETURNStext |
| 42 | +AS'$libdir/pgcrypto', |
| 43 | +'pg_gen_salt_rounds' LANGUAGE'C'; |
| 44 | + |
| 45 | +CREATEFUNCTIONencrypt(bytea,bytea,text) RETURNSbytea |
| 46 | +AS'$libdir/pgcrypto', |
| 47 | +'pg_encrypt' LANGUAGE'C'; |
| 48 | + |
| 49 | +CREATEFUNCTIONdecrypt(bytea,bytea,text) RETURNSbytea |
| 50 | +AS'$libdir/pgcrypto', |
| 51 | +'pg_decrypt' LANGUAGE'C'; |
| 52 | + |
| 53 | +CREATEFUNCTIONencrypt_iv(bytea,bytea,bytea,text) RETURNSbytea |
| 54 | +AS'$libdir/pgcrypto', |
| 55 | +'pg_encrypt_iv' LANGUAGE'C'; |
| 56 | + |
| 57 | +CREATEFUNCTIONdecrypt_iv(bytea,bytea,bytea,text) RETURNSbytea |
| 58 | +AS'$libdir/pgcrypto', |
| 59 | +'pg_decrypt_iv' LANGUAGE'C'; |
| 60 | + |
| 61 | +CREATEFUNCTIONcipher_exists(text) RETURNS bool |
| 62 | +AS'$libdir/pgcrypto', |
| 63 | +'pg_cipher_exists' LANGUAGE'C'; |
| 64 | + |
| 65 | + |