E-Maj functions list

E-Maj functions that are available to users are listed in alphabetic order below. They are all callable by roles having emaj_adm privileges. The chart also specifies those callable by emaj_viewer roles (sign (V) behind the function name).

Functions Input parameters Output data
emaj_alter_group
group TEXT,
[mark TEXT]
#.tables.and.seq INT
emaj_alter_groups
groups.array TEXT[],
[mark TEXT]
#.tables.and.seq INT
emaj_cleanup_rollback_state   #.rollback INT
emaj_comment_group
group TEXT,
comment TEXT
 
emaj_comment_mark_group
group TEXT,
mark TEXT,
comment TEXT
 
emaj_consolidate_rollback_group
group TEXT,
end.rollback.mark TEXT
#.tables.and.seq INT
emaj_create_group
group TEXT,
[is.rollbackable BOOLEAN],
[is.empty BOOLEAN]
#.tables.and.seq INT
emaj_delete_before_mark_group
group TEXT,
mark TEXT
#.deleted.marks INT
emaj_delete_mark_group
group TEXT,
mark TEXT
1 INT
emaj_detailed_log_stat_group (V)
group TEXT,
start.mark TEXT,
end.mark TEXT
SETOF emaj_detailed_log_stat_type
emaj_detailed_log_stat_groups (V)
groups.array TEXT[],
start.mark TEXT,
end.mark TEXT
SETOF emaj_detailed_log_stat_type
emaj_disable_protection_by_event_triggers   #.triggers INT
emaj_drop_group
group TEXT
#.tables.and.seq INT
emaj_enable_protection_by_event_triggers   #.triggers INT
emaj_estimate_rollback_group (V)
group TEXT,
mark TEXT
duration INTERVAL
emaj_estimate_rollback_groups (V)
groups.array TEXT[],
mark TEXT
duration INTERVAL
emaj_force_drop_group
group TEXT
#.tables.and.seq INT
emaj_force_stop_group
group TEXT
#.tables.and.seq INT
emaj_gen_sql_group
group TEXT,
start.mark TEXT,
end.mark TEXT,
output.file.path TEXT,
[tables.seq.array TEXT[]]
#.gen.statements BIGINT
emaj_gen_sql_groups
groups.array TEXT[],
start.mark TEXT,
end.mark TEXT,
output.file.path TEXT,
[tables.seq.array TEXT[]]
#.gen.statements BIGINT
emaj_get_consolidable_rollbacks (V)   SETOF emaj_consolidable_rollback_type
emaj_get_previous_mark_group (V)
group TEXT,
date.time TIMESTAMPTZ
mark TEXT
emaj_get_previous_mark_group (V)
group TEXT,
mark TEXT
mark TEXT
emaj_ignore_app_trigger
action TEXT,
schema TEXT,
table TEXT,
trigger TEXT
#.triggers INT
emaj_log_stat_group (V)
group TEXT,
start.mark TEXT,
end.mark TEXT
SETOF emaj_log_stat_type
emaj_log_stat_groups (V)
groups.array TEXT[],
start.mark TEXT,
end.mark TEXT
SETOF emaj_log_stat_type
emaj_logged_rollback_group
group TEXT,
mark TEXT,
is_alter_group_allowed
BOOLEAN
SETOF (severity TEXT, message TEXT)
emaj_logged_rollback_groups
groups.array TEXT[],
mark TEXT,
is_alter_group_allowed
BOOLEAN
SETOF (severity TEXT, message TEXT)
emaj_protect_group
group TEXT
0/1 INT
emaj_protect_mark_group
group TEXT,
mark TEXT
0/1 INT
emaj_rename_mark_group
group TEXT,
mark TEXT,
new.name TEXT
 
emaj_reset_group
group TEXT
#.tables.and.seq INT
emaj_rollback_activity (V)   SETOF emaj_rollback_activity_type
emaj_rollback_group
group TEXT,
mark TEXT,
is_alter_group_allowed
BOOLEAN
SETOF (severity TEXT, message TEXT)
emaj_rollback_groups
groups.array TEXT[],
mark TEXT,
is_alter_group_allowed
BOOLEAN
SETOF (severity TEXT, message TEXT)
emaj_set_mark_group
group TEXT,
[mark TEXT]
#.tables.and.seq INT
emaj_set_mark_groups
groups.array TEXT[],
[mark TEXT]
#.tables.and.seq INT
emaj_snap_group
group TEXT,
directory TEXT,
copy.options TEXT
#.tables.and.seq INT
emaj_snap_log_group
group TEXT,
start.mark TEXT,
end.mark TEXT,
directory TEXT,
copy.options TEXT
#.tables.and.seq INT
emaj_start_group
group TEXT,
[mark TEXT],
[reset.log BOOLEAN]
#.tables.and.seq INT
emaj_start_groups
groups.array TEXT[],
[mark TEXT],
[reset.log BOOLEAN]
#.tables.and.seq INT
emaj_stop_group
group TEXT,
[mark TEXT]
#.tables.and.seq INT
emaj_stop_groups
groups.array TEXT[],
[mark TEXT]
#.tables.and.seq INT
emaj_unprotect_group
group TEXT
0/1 INT
emaj_unprotect_mark_group
group TEXT,
mark TEXT
0/1 INT
emaj_verify_all (V)   Setof TEXT