9.21. USER

Available in

DSQL, PSQL

Syntax

USER

Type

VARCHAR(31)

Description

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

Example

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