surveilr_udi_dal_postgresql()

Registers a virtual table module surveilr_udi_dal_postgresql that interacts with files stored in PostgreSQL.This virtual table allows structured querying of file metadata and content stored in a PostgreSQL table.The virtual table exposes the following columns:- name: TEXT - The name of the file- path: TEXT - The full path/key of the file- last_modified: TEXT - The last modified timestamp- content: BLOB - The binary content of the file- size: INTEGER - The size in bytes- content_type: TEXT - The file extension/type- digest: TEXT - The MD5 hash of the content- connection_string: HIDDEN TEXT - PostgreSQL connection string- table_name: HIDDEN TEXT - Table name to read from

Introduced in version .

Parameters

surveilr_anonymize_date surveilr_anonymize_email surveilr_anonymize_name surveilr_assert_tabular_column surveilr_assert_tabular_object surveilr_device_id surveilr_ensure_extension surveilr_ensure_function surveilr_ensure_orchestration_nature surveilr_extension_docs surveilr_function_docs surveilr_generalize_age surveilr_get_orchestration_session_info surveilr_hash surveilr_ingest_session_id surveilr_mask surveilr_mask_address surveilr_mask_dob surveilr_mask_financial surveilr_mask_phone surveilr_notebook_cell_exec surveilr_orchestration_context_session_id surveilr_orchestration_nature_id surveilr_orchestration_session_append_exec surveilr_orchestration_session_append_log surveilr_osquery_ms_create_behaviour surveilr_osquery_ms_retrieve_behavior_id surveilr_osquery_ms_update_behavior surveilr_udi_dal_dropbox surveilr_udi_dal_fs surveilr_udi_dal_gdrive surveilr_udi_dal_postgresql surveilr_udi_dal_s3 surveilr_version