9.7. CURRENT_USER

Available in

DSQL, PSQL

Syntax

CURRENT_USER

Type

VARCHAR(31)

Description

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

Example

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