11.7 CURRENT_USER

Available inDSQL, PSQL

TypeVARCHAR(63)

Syntax

CURRENT_USER

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

Example

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