egdb3_11_7
.acq
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
create_acq_lifecycle(sch text, tbl text)
Parameters
Name
Type
Mode
sch
text
IN
tbl
text
IN
Definition
BEGIN EXECUTE $$ CREATE OR REPLACE VIEW acq.$$ || sch || $$_$$ || tbl || $$_lifecycle AS SELECT -1, now() as audit_time, '-' as audit_action, * FROM $$ || sch || $$.$$ || tbl || $$ UNION ALL SELECT * FROM acq.$$ || sch || $$_$$ || tbl || $$_history; $$; RETURN TRUE; END;