SHOW SUBSCRIPTIONS

Use the SHOW SUBSCRIPTIONS command to list all subscriptions in a schema.

Syntax

SHOW SUBSCRIPTIONS [ FROM schema_name ] [ LIKE_expression ];

Parameters

Parameter or clause	Description
schema_name	The schema of the subscriptions to be listed. If not specified, subscriptions from all schemas in the current schema search_path will be listed.
LIKE_expression	Filters the output based on names by applying pattern matching. See details in LIKE pattern matching expressions.

Example

SHOW SUBSCRIPTIONS;

        Name
---------------------
 public.my_sub
 public.order_events_sub
 public.metrics_stream_sub
(3 rows)

Starting from v2.7.0, the Name column in the output includes the schema name as a prefix (e.g., public.subscription_name). This helps distinguish subscriptions with the same name in different schemas when querying across multiple schemas in the search path.

Related topics

Subscribe to real-time updates

Learn more about subscriptions

SHOW SUBSCRIPTION CURSORS

Show subscription cursors