Skip to content

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

ValuePostgreSQL Level
infoINFO and above
noticeNOTICE and above
warningWARNING 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

Released under the MIT License.