Available inDSQL, PSQL

Syntax

USER

TypeVARCHAR(31)

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

Example

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