Skip to content

SSE_EVENTS_LEVEL

Also known as

sse_level (with or without @ prefix)

Set the minimum PostgreSQL notice level for Server-Sent Events.

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

Comments

Released under the MIT License.