SQL Reference

This section documents all SQL functions and views exported by pg_ripple.

Conventions

Term format — all IRI, blank node, and literal arguments use N-Triples notation:

Kind	Format	Example
IRI	`<…>`	`<https://example.org/alice>`
Blank node	`_:…`	`_:b0`
Plain literal	`"…"`	`"Alice"`
Language-tagged literal	`"…"@lang`	`"Alice"@en`
Typed literal	`"…"^^<type>`	`"30"^^<http://www.w3.org/2001/XMLSchema#integer>`

NULL wildcards — in find/delete functions, NULL matches any value for that position.

Schema — all public functions are in the pg_ripple schema. Internal tables are in _pg_ripple.

Function index

Function	Section
`insert_triple`	Triple CRUD
`delete_triple`	Triple CRUD
`find_triples`	Triple CRUD
`triple_count`	Triple CRUD
`load_ntriples`	Bulk Loading
`load_ntriples_file`	Bulk Loading
`load_turtle`	Bulk Loading
`load_turtle_file`	Bulk Loading
`load_nquads`	Bulk Loading
`load_nquads_file`	Bulk Loading
`load_trig`	Bulk Loading
`load_trig_file`	Bulk Loading
`load_rdfxml`	Bulk Loading
`load_rdfxml_file`	Bulk Loading
`load_ntriples_into_graph`	Bulk Loading
`load_turtle_into_graph`	Bulk Loading
`load_rdfxml_into_graph`	Bulk Loading
`load_ntriples_file_into_graph`	Bulk Loading
`load_turtle_file_into_graph`	Bulk Loading
`load_rdfxml_file_into_graph`	Bulk Loading
`create_graph`	Named Graphs
`drop_graph`	Named Graphs
`list_graphs`	Named Graphs
`find_triples_in_graph`	Named Graphs
`triple_count_in_graph`	Named Graphs
`delete_triple_from_graph`	Named Graphs
`clear_graph`	Named Graphs
`sparql`	SPARQL Queries
`sparql_ask`	SPARQL Queries
`sparql_explain`	SPARQL Queries
`sparql_construct`	SPARQL Queries
`sparql_describe`	SPARQL Queries
`sparql_update`	SPARQL Update
`fts_index`	Full-Text Search
`fts_search`	Full-Text Search
`encode_triple`	RDF-star
`decode_triple`	RDF-star
`get_statement`	RDF-star
`encode_term`	Dictionary
`decode_id`	Dictionary
`decode_id_full`	Dictionary
`lookup_iri`	Dictionary
`register_prefix`	Prefix Registry
`prefixes`	Prefix Registry
`export_ntriples`	Serialization & Export
`export_nquads`	Serialization & Export
`export_turtle`	Serialization & Export
`export_turtle_stream`	Serialization & Export
`export_jsonld`	Serialization & Export
`export_jsonld_stream`	Serialization & Export
`sparql_construct_turtle`	Serialization & Export
`sparql_construct_jsonld`	Serialization & Export
`sparql_describe_turtle`	Serialization & Export
`sparql_describe_jsonld`	Serialization & Export
`load_shacl`	SHACL Validation
`validate`	SHACL Validation
`list_shapes`	SHACL Validation
`drop_shape`	SHACL Validation
`process_validation_queue`	SHACL Validation
`validation_queue_length`	SHACL Validation
`dead_letter_count`	SHACL Validation
`dead_letter_queue`	SHACL Validation
`drain_dead_letter_queue`	SHACL Validation
`enable_shacl_monitors`	SHACL Validation
`load_rules`	Datalog Reasoning
`load_rules_builtin`	Datalog Reasoning
`infer`	Datalog Reasoning
`check_constraints`	Datalog Reasoning
`list_rules`	Datalog Reasoning
`drop_rules`	Datalog Reasoning
`enable_rule_set`	Datalog Reasoning
`disable_rule_set`	Datalog Reasoning
`prewarm_dictionary_hot`	Datalog Reasoning
`create_sparql_view`	Materialized Views
`drop_sparql_view`	Materialized Views
`list_sparql_views`	Materialized Views
`create_datalog_view`	Materialized Views
`create_datalog_view_from_rule_set`	Materialized Views
`drop_datalog_view`	Materialized Views
`list_datalog_views`	Materialized Views
`create_extvp`	Materialized Views
`drop_extvp`	Materialized Views
`list_extvp`	Materialized Views
`pg_trickle_available`	Materialized Views
`compact`	Administration
`stats`	Administration
`subscribe`	Administration
`unsubscribe`	Administration
`htap_migrate_predicate`	Administration
`subject_predicates`	Administration
`object_predicates`	Administration
`deduplicate_predicate`	Administration
`deduplicate_all`	Administration
`vacuum`	Administration
`reindex`	Administration
`vacuum_dictionary`	Administration
`dictionary_stats`	Administration
`enable_graph_rls`	Administration
`grant_graph`	Administration
`revoke_graph`	Administration
`list_graph_access`	Administration
`schema_summary`	Administration
`enable_schema_summary`	Administration
`plan_cache_stats`	Administration
`plan_cache_reset`	Administration