Skip to content

Home > extract-pg-schema > Trigger

Trigger interface

Trigger on a table or view.

Signature:

typescript
export interface Trigger

Properties

Property

Modifiers

Type

Description

actionTiming

"BEFORE" | "AFTER" | "INSTEAD OF"

Timing of the trigger (BEFORE, AFTER, INSTEAD OF).

comment

string | null

Comment on the trigger, if any.

condition

string | null

WHEN condition for the trigger, if any.

enabled

boolean

Whether the trigger is enabled.

eventManipulation

("INSERT" | "UPDATE" | "DELETE" | "TRUNCATE")[]

Events that fire the trigger (INSERT, UPDATE, DELETE, TRUNCATE).

functionArgs

string[]

Arguments passed to the function.

functionName

string

Name of the function called by the trigger.

functionSchema

string

Schema of the function called by the trigger.

informationSchemaValue

InformationSchemaTrigger

Information schema value for the trigger.

name

string

Name of the trigger.

orientation

"ROW" | "STATEMENT"

Orientation: ROW or STATEMENT.