SSE_EVENTS_LEVEL
Set the minimum PostgreSQL notice level for Server-Sent Events.
Keywords
sse_level, sse_events_level
Syntax
sse_level <level>
sse_events_level <level>Values
| Value | PostgreSQL Level |
|---|---|
info | INFO and above |
notice | NOTICE and above |
warning | WARNING only |
Examples
Info Level (All Messages)
sql
comment on function verbose_process() is
'HTTP POST
sse /events
sse_level info';Receives: RAISE INFO, RAISE NOTICE, RAISE WARNING
Notice Level
sql
comment on function standard_process() is
'HTTP POST
sse /events
sse_level notice';Receives: RAISE NOTICE, RAISE WARNING
Warning Level Only
sql
comment on function quiet_process() is
'HTTP POST
sse /events
sse_level warning';Receives: RAISE WARNING only
Related
- NpgsqlRest Options configuration - Configure SSE options
- Comment Annotations Guide - How annotations work
- Configuration Guide - How configuration works
Related Annotations
- SSE - Enable Server-Sent Events
- SSE_EVENTS_SCOPE - Set distribution scope