9.7CURRENT_USER

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