audit_view(target_view regclass, audit_query_text boolean, ignored_cols text[], uid_cols text[])

ADD auditing support TO a VIEW.

Arguments: target_view: TABLE name, schema qualified IF NOT ON search_path audit_query_text: Record the text of the client query that triggered the audit event? ignored_cols: COLUMNS TO exclude FROM UPDATE diffs, IGNORE updates that CHANGE only ignored cols. uid_cols: MANDATORY COLUMNS to use to uniquely identify a row from the view (in order to replay UPDATE and DELETE)

Example: SELECT tww_sys.audit_view(‘view_schema.view_name’, ‘true’::BOOLEAN, ‘field_to_ignore’::text[], ‘obj_id’::text[])

[]: ./../null []: ./../null