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