CURRENT_USER

Available in: DSQL, PSQL

Added in: 1.0

Description

CURRENT_USER is a context variable containing the name of the currently connected user. It is fully equivalent to USER.

Type: VARCHAR(31)

Example

create trigger bi_customers for customers before insert as
begin
  New.added_by = CURRENT_USER;
  New.purchases = 0;
end