contrib/pgcrypto/pgcrypto.sql.in

   1 /* $PostgreSQL$ */
   2
   3 -- Adjust this setting to control where the objects get created.
   4 SET search_path = public;
   5
   6 CREATE OR REPLACE FUNCTION digest(text, text)
   7 RETURNS bytea
   8 AS 'MODULE_PATHNAME', 'pg_digest'
   9 LANGUAGE C IMMUTABLE STRICT;
  10
  11 CREATE OR REPLACE FUNCTION digest(bytea, text)
  12 RETURNS bytea
  13 AS 'MODULE_PATHNAME', 'pg_digest'
  14 LANGUAGE C IMMUTABLE STRICT;
  15
  16 CREATE OR REPLACE FUNCTION hmac(text, text, text)
  17 RETURNS bytea
  18 AS 'MODULE_PATHNAME', 'pg_hmac'
  19 LANGUAGE C IMMUTABLE STRICT;
  20
  21 CREATE OR REPLACE FUNCTION hmac(bytea, bytea, text)
  22 RETURNS bytea
  23 AS 'MODULE_PATHNAME', 'pg_hmac'
  24 LANGUAGE C IMMUTABLE STRICT;
  25
  26 CREATE OR REPLACE FUNCTION crypt(text, text)
  27 RETURNS text
  28 AS 'MODULE_PATHNAME', 'pg_crypt'
  29 LANGUAGE C IMMUTABLE STRICT;
  30
  31 CREATE OR REPLACE FUNCTION gen_salt(text)
  32 RETURNS text
  33 AS 'MODULE_PATHNAME', 'pg_gen_salt'
  34 LANGUAGE C VOLATILE STRICT;
  35
  36 CREATE OR REPLACE FUNCTION gen_salt(text, int4)
  37 RETURNS text
  38 AS 'MODULE_PATHNAME', 'pg_gen_salt_rounds'
  39 LANGUAGE C VOLATILE STRICT;
  40
  41 CREATE OR REPLACE FUNCTION encrypt(bytea, bytea, text)
  42 RETURNS bytea
  43 AS 'MODULE_PATHNAME', 'pg_encrypt'
  44 LANGUAGE C IMMUTABLE STRICT;
  45
  46 CREATE OR REPLACE FUNCTION decrypt(bytea, bytea, text)
  47 RETURNS bytea
  48 AS 'MODULE_PATHNAME', 'pg_decrypt'
  49 LANGUAGE C IMMUTABLE STRICT;
  50
  51 CREATE OR REPLACE FUNCTION encrypt_iv(bytea, bytea, bytea, text)
  52 RETURNS bytea
  53 AS 'MODULE_PATHNAME', 'pg_encrypt_iv'
  54 LANGUAGE C IMMUTABLE STRICT;
  55
  56 CREATE OR REPLACE FUNCTION decrypt_iv(bytea, bytea, bytea, text)
  57 RETURNS bytea
  58 AS 'MODULE_PATHNAME', 'pg_decrypt_iv'
  59 LANGUAGE C IMMUTABLE STRICT;
  60
  61 CREATE OR REPLACE FUNCTION gen_random_bytes(int4)
  62 RETURNS bytea
  63 AS 'MODULE_PATHNAME', 'pg_random_bytes'
  64 LANGUAGE 'C' VOLATILE STRICT;
  65
  66 --
  67 -- pgp_sym_encrypt(data, key)
  68 --
  69 CREATE OR REPLACE FUNCTION pgp_sym_encrypt(text, text)
  70 RETURNS bytea
  71 AS 'MODULE_PATHNAME', 'pgp_sym_encrypt_text'
  72 LANGUAGE C STRICT;
  73
  74 CREATE OR REPLACE FUNCTION pgp_sym_encrypt_bytea(bytea, text)
  75 RETURNS bytea
  76 AS 'MODULE_PATHNAME', 'pgp_sym_encrypt_bytea'
  77 LANGUAGE C STRICT;
  78
  79 --
  80 -- pgp_sym_encrypt(data, key, args)
  81 --
  82 CREATE OR REPLACE FUNCTION pgp_sym_encrypt(text, text, text)
  83 RETURNS bytea
  84 AS 'MODULE_PATHNAME', 'pgp_sym_encrypt_text'
  85 LANGUAGE C STRICT;
  86
  87 CREATE OR REPLACE FUNCTION pgp_sym_encrypt_bytea(bytea, text, text)
  88 RETURNS bytea
  89 AS 'MODULE_PATHNAME', 'pgp_sym_encrypt_bytea'
  90 LANGUAGE C STRICT;
  91
  92 --
  93 -- pgp_sym_decrypt(data, key)
  94 --
  95 CREATE OR REPLACE FUNCTION pgp_sym_decrypt(bytea, text)
  96 RETURNS text
  97 AS 'MODULE_PATHNAME', 'pgp_sym_decrypt_text'
  98 LANGUAGE C IMMUTABLE STRICT;
  99
 100 CREATE OR REPLACE FUNCTION pgp_sym_decrypt_bytea(bytea, text)
 101 RETURNS bytea
 102 AS 'MODULE_PATHNAME', 'pgp_sym_decrypt_bytea'
 103 LANGUAGE C IMMUTABLE STRICT;
 104
 105 --
 106 -- pgp_sym_decrypt(data, key, args)
 107 --
 108 CREATE OR REPLACE FUNCTION pgp_sym_decrypt(bytea, text, text)
 109 RETURNS text
 110 AS 'MODULE_PATHNAME', 'pgp_sym_decrypt_text'
 111 LANGUAGE C IMMUTABLE STRICT;
 112
 113 CREATE OR REPLACE FUNCTION pgp_sym_decrypt_bytea(bytea, text, text)
 114 RETURNS bytea
 115 AS 'MODULE_PATHNAME', 'pgp_sym_decrypt_bytea'
 116 LANGUAGE C IMMUTABLE STRICT;
 117
 118 --
 119 -- pgp_pub_encrypt(data, key)
 120 --
 121 CREATE OR REPLACE FUNCTION pgp_pub_encrypt(text, bytea)
 122 RETURNS bytea
 123 AS 'MODULE_PATHNAME', 'pgp_pub_encrypt_text'
 124 LANGUAGE C STRICT;
 125
 126 CREATE OR REPLACE FUNCTION pgp_pub_encrypt_bytea(bytea, bytea)
 127 RETURNS bytea
 128 AS 'MODULE_PATHNAME', 'pgp_pub_encrypt_bytea'
 129 LANGUAGE C STRICT;
 130
 131 --
 132 -- pgp_pub_encrypt(data, key, args)
 133 --
 134 CREATE OR REPLACE FUNCTION pgp_pub_encrypt(text, bytea, text)
 135 RETURNS bytea
 136 AS 'MODULE_PATHNAME', 'pgp_pub_encrypt_text'
 137 LANGUAGE C STRICT;
 138
 139 CREATE OR REPLACE FUNCTION pgp_pub_encrypt_bytea(bytea, bytea, text)
 140 RETURNS bytea
 141 AS 'MODULE_PATHNAME', 'pgp_pub_encrypt_bytea'
 142 LANGUAGE C STRICT;
 143
 144 --
 145 -- pgp_pub_decrypt(data, key)
 146 --
 147 CREATE OR REPLACE FUNCTION pgp_pub_decrypt(bytea, bytea)
 148 RETURNS text
 149 AS 'MODULE_PATHNAME', 'pgp_pub_decrypt_text'
 150 LANGUAGE C IMMUTABLE STRICT;
 151
 152 CREATE OR REPLACE FUNCTION pgp_pub_decrypt_bytea(bytea, bytea)
 153 RETURNS bytea
 154 AS 'MODULE_PATHNAME', 'pgp_pub_decrypt_bytea'
 155 LANGUAGE C IMMUTABLE STRICT;
 156
 157 --
 158 -- pgp_pub_decrypt(data, key, psw)
 159 --
 160 CREATE OR REPLACE FUNCTION pgp_pub_decrypt(bytea, bytea, text)
 161 RETURNS text
 162 AS 'MODULE_PATHNAME', 'pgp_pub_decrypt_text'
 163 LANGUAGE C IMMUTABLE STRICT;
 164
 165 CREATE OR REPLACE FUNCTION pgp_pub_decrypt_bytea(bytea, bytea, text)
 166 RETURNS bytea
 167 AS 'MODULE_PATHNAME', 'pgp_pub_decrypt_bytea'
 168 LANGUAGE C IMMUTABLE STRICT;
 169
 170 --
 171 -- pgp_pub_decrypt(data, key, psw, arg)
 172 --
 173 CREATE OR REPLACE FUNCTION pgp_pub_decrypt(bytea, bytea, text, text)
 174 RETURNS text
 175 AS 'MODULE_PATHNAME', 'pgp_pub_decrypt_text'
 176 LANGUAGE C IMMUTABLE STRICT;
 177
 178 CREATE OR REPLACE FUNCTION pgp_pub_decrypt_bytea(bytea, bytea, text, text)
 179 RETURNS bytea
 180 AS 'MODULE_PATHNAME', 'pgp_pub_decrypt_bytea'
 181 LANGUAGE C IMMUTABLE STRICT;
 182
 183 --
 184 -- PGP key ID
 185 --
 186 CREATE OR REPLACE FUNCTION pgp_key_id(bytea)
 187 RETURNS text
 188 AS 'MODULE_PATHNAME', 'pgp_key_id_w'
 189 LANGUAGE C IMMUTABLE STRICT;
 190
 191 --
 192 -- pgp armor
 193 --
 194 CREATE OR REPLACE FUNCTION armor(bytea)
 195 RETURNS text
 196 AS 'MODULE_PATHNAME', 'pg_armor'
 197 LANGUAGE C IMMUTABLE STRICT;
 198
 199 CREATE OR REPLACE FUNCTION dearmor(text)
 200 RETURNS bytea
 201 AS 'MODULE_PATHNAME', 'pg_dearmor'
 202 LANGUAGE C IMMUTABLE STRICT;
 203