| -- | |
| -- 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'); | |
| SELECT decode('666f6f', 'hex'); | |
| -- check error handling | |
| select gen_salt('foo'); | |
| select digest('foo', 'foo'); | |
| select hmac('foo', 'foo', 'foo'); | |
| select encrypt('foo', 'foo', 'foo'); |