SQLStreams

the messaging platform that is just Postgres

You last visited on 9999-99-99 Show what's new since then

List consumer groups

Edit this page
Consumer · Related pages
Posted: 2026-09-16 · Report this thread
brandon Site Admin brandon profile Posts: 96
Consumers(ctx context.Context) ([]*Consumer, error)

Lists the consumer groups registered on a stream, ordered by name. Reading the list does not create groups, change their settings, or advance their positions in the stream.

Example

List groups on the payments.requested stream using an initialized client and the example payload.

payments := client.Stream[PaymentRequestedV1]("payments.requested")
groups, err := payments.Consumers(ctx)
if err != nil {
return err
}
for _, group := range groups {
fmt.Println(group.Name)
}

Parameters

Parameter Type Required Description
ctx context.Context Yes Cancelling this context or reaching its deadline interrupts the database read.

Returns

Condition Return value
Stream has registered groups (groups, nil), where groups contains consumer group objects ordered by name.
Stream has no groups (groups, nil), where len(groups) == 0.
Read fails, including a missing stream (nil, err). See Errors.

CLI

sqlstreams consumer list payments.requested

Prints group names and ids, ordered by name, and exits with status 0. An existing stream with no groups prints no consumers registered and also exits with status 0. See consumer list for output formats and flags.

Errors

Error When
ErrStreamNotFound The stream is not registered.
Validation error The stream name is empty.
Database error The groups cannot be read.
Context cancellation or deadline error The read is interrupted by its context.