provsql

pig build pkg provsql;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install provsql;		# install via package name, for the active PG version

pig install provsql -v 18;   # install for PG 18
pig install provsql -v 17;   # install for PG 17
pig install provsql -v 16;   # install for PG 16
pig install provsql -v 15;   # install for PG 15
pig install provsql -v 14;   # install for PG 14

shared_preload_libraries = 'provsql';

CREATE EXTENSION provsql CASCADE; -- requires uuid-ossp

shared_preload_libraries = 'provsql'

CREATE EXTENSION provsql CASCADE;

SELECT provsql.add_provenance('mytable');

SELECT name, provenance()
FROM mytable;

SELECT provsql.remove_provenance('mytable');

SELECT create_provenance_mapping('my_mapping', 'mytable', 'column_name');
SELECT create_provenance_mapping_view('my_mapping_view', 'mytable', 'column_name');

SELECT set_prob(provenance(), 0.8)
FROM mytable
WHERE id = 1;

SELECT city,
       provenance_evaluate(
         provenance(),
         'personnel_level',
         'unclassified'::classification_level,
         'security_plus',
         'security_times'
       )
FROM (SELECT DISTINCT city FROM personnel) AS t;

SELECT shapley(provenance(), m.token)
FROM my_mapping AS m;

SET provsql.where_provenance = on;
SET provsql.update_provenance = on;