1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
CREATE EXTENSION pg_snakeoil;
-- ------------------------------------------------------------------------
-- Management Functions
-- ------------------------------------------------------------------------
SELECT so_update_signatures();
-- ------------------------------------------------------------------------
-- Text Functions
-- ------------------------------------------------------------------------
SELECT so_is_infected('the quick brown fox jumps over the lazy dog');
SELECT so_virus_name('the quick brown fox jumps over the lazy dog');
SELECT so_is_infected('Hello World!');
SELECT so_virus_name('Hello World!');
-- ------------------------------------------------------------------------
-- bytea Functions
-- ------------------------------------------------------------------------
SELECT so_is_infected('the quick brown fox jumps over the lazy dog'::bytea);
SELECT so_virus_name('the quick brown fox jumps over the lazy dog'::bytea);
SELECT so_is_infected('Hello World!'::bytea);
SELECT so_virus_name('Hello World!'::bytea);
|