dbschema 0.1.0

Define database schema's as HCL files, and generate idempotent SQL migrations
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38

# Event Trigger

Fires a function in response to database-wide events.

```hcl
event_trigger "log_ddl" {
  event   = "ddl_command_start"
  tags    = ["CREATE TABLE"]
  function = "ddl_logger"
}
```

## Attributes
- `name` (label): trigger name.
- `event` (string): event name such as `ddl_command_start`.
- `tags` (array of strings): optional filter on `TAG IN (...)`.
- `function` (string): function to execute.
- `function_schema` (string, optional): schema of the function.
- `comment` (string, optional): documentation comment.

## Examples

```hcl
function "audit_ddl" {
  language = "plpgsql"
  returns  = "event_trigger"
  body = <<-SQL
  BEGIN
    RAISE NOTICE 'DDL: %', tg_tag;
  END;
  SQL
}

event_trigger "audit_ddl_start" {
  event = "ddl_command_start"
  function = "audit_ddl"
}
```