Available inDSQL, PSQL

Syntax

CURRENT_USER

TypeVARCHAR(31)

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

Example

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