-
Notifications
You must be signed in to change notification settings - Fork 0
/
pgbench_alter_raw.sql
21 lines (14 loc) · 1.07 KB
/
pgbench_alter_raw.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
ALTER TABLE pgbench_history ALTER delta TYPE bytea USING encrypt(delta::text::bytea, 'secret'::bytea,'aes'::text),
ALTER mtime TYPE bytea USING encrypt(mtime::text::bytea, 'secret'::bytea,'aes'::text),
ALTER filler TYPE bytea USING encrypt(filler::bytea, 'secret'::bytea,'aes'::text);
-- Test
-- SELECT decrypt(delta,'secret'::bytea,'aes'::text)::int from pgbench_history;
ALTER TABLE pgbench_tellers
ALTER tbalance TYPE bytea USING encrypt(tbalance::text::bytea, 'secret'::bytea,'aes'::text),
ALTER filler TYPE bytea USING encrypt(filler::bytea, 'secret'::bytea,'aes'::text);
ALTER TABLE pgbench_branches
ALTER bbalance TYPE bytea USING encrypt(bbalance::text::bytea, 'secret'::bytea,'aes'::text),
ALTER filler TYPE bytea USING encrypt(filler::bytea, 'secret'::bytea,'aes'::text);
ALTER TABLE pgbench_accounts
ALTER abalance TYPE bytea USING encrypt(abalance::text::bytea, 'secret'::bytea,'aes'::text),
ALTER filler TYPE bytea USING encrypt(filler::bytea, 'secret'::bytea,'aes'::text);