| -- |
| -- init pgcrypto |
| -- |
| CREATE EXTENSION pgcrypto; |
| -- ensure consistent test output regardless of the default bytea format |
| SET bytea_output TO escape; |
| -- check for encoding fn's |
| SELECT encode('foo', 'hex'); |
| encode |
| -------- |
| 666f6f |
| (1 row) |
| |
| SELECT decode('666f6f', 'hex'); |
| decode |
| -------- |
| foo |
| (1 row) |
| |
| -- check error handling |
| select gen_salt('foo'); |
| ERROR: gen_salt: Unknown salt algorithm |
| select digest('foo', 'foo'); |
| ERROR: Cannot use "foo": No such hash algorithm |
| select hmac('foo', 'foo', 'foo'); |
| ERROR: Cannot use "foo": No such hash algorithm |
| select encrypt('foo', 'foo', 'foo'); |
| ERROR: Cannot use "foo": No such cipher algorithm |