CURRENT_USER

`CURRENT_USER`

Name of the user of the current connection

Type

VARCHAR(63)

Syntax

CURRENT_USER

CURRENT_USER is equivalent to [fblangref50-contextvars-user].

Example

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

Indicates if the trigger fired for a DELETE operation

Available in

PSQL — DML triggers only

Type

BOOLEAN

Syntax

DELETING

Example

if (deleting) then
begin
  insert into Removed_Cars (id, make, model, removed)
    values (old.id, old.make, old.model, current_timestamp);
end