11.7. CURRENT_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