11.7CURRENT_USER

Available inDSQL, PSQL

TypeVARCHAR(31)

Syntax

  |CURRENT_USER

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

Example

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