SQL reference
- Overview
- Commands
- Overview
- ALTER CONNECTION
- ALTER DATABASE
- ALTER FUNCTION
- ALTER INDEX
- ALTER MATERIALIZED VIEW
- ALTER SCHEMA
- ALTER SECRET
- ALTER SINK
- ALTER SOURCE
- ALTER SUBSCRIPTION
- ALTER SWAP
- ALTER SYSTEM
- ALTER TABLE
- ALTER USER
- ALTER VIEW
- AS CHANGELOG
- BEGIN
- CANCEL JOBS
- COMMENT ON
- COMMIT
- CREATE AGGREGATE
- CREATE CONNECTION
- CREATE DATABASE
- CREATE FUNCTION
- CREATE INDEX
- CREATE MATERIALIZED VIEW
- CREATE SCHEMA
- CREATE SECRET
- CREATE SINK INTO
- CREATE SINK
- CREATE SOURCE
- CREATE TABLE
- CREATE USER
- CREATE VIEW
- DELETE
- DESCRIBE
- DISCARD
- DROP AGGREGATE
- DROP CONNECTION
- DROP DATABASE
- DROP FUNCTION
- DROP INDEX
- DROP MATERIALIZED VIEW
- DROP SCHEMA
- DROP SECRET
- DROP SINK
- DROP SOURCE
- DROP TABLE
- DROP USER
- DROP VIEW
- EXPLAIN
- EXPLAIN ANALYZE
- FLUSH
- GRANT
- INSERT
- RECOVER
- REVOKE
- SELECT
- SET BACKGROUND_DDL
- SET RW_IMPLICIT_FLUSH
- SET TIME ZONE
- SET
- SHOW CLUSTER
- SHOW COLUMNS
- SHOW CONNECTIONS
- SHOW CREATE INDEX
- SHOW CREATE MATERIALIZED VIEW
- SHOW CREATE SINK
- SHOW CREATE SOURCE
- SHOW CREATE TABLE
- SHOW CREATE VIEW
- SHOW CURSORS
- SHOW DATABASES
- SHOW FUNCTIONS
- SHOW INDEXES
- SHOW INTERNAL TABLES
- SHOW JOBS
- SHOW MATERIALIZED VIEWS
- SHOW PARAMETERS
- SHOW PROCESSLIST
- SHOW SCHEMAS
- SHOW SINKS
- SHOW SOURCES
- SHOW SUBSCRIPTION CURSORS
- SHOW TABLES
- SHOW VIEWS
- START TRANSACTION
- UPDATE
- Query syntax
- Data types
- Functions and operators
- Identifiers
- System catalogs
- Psql commands
Commands
SHOW SUBSCRIPTION CURSORS
Use the SHOW SUBSCRIPTION CURSORS command to display all subscription cursors in the current session.
Syntax
Copy
Ask AI
SHOW SUBSCRIPTION CURSORS;
Examples
Copy
Ask AI
SHOW SUBSCRIPTION CURSORS;
------RESULT
Name | SubscriptionName
------+------------------
cur2 | sub
cur | sub
(2 rows)
Was this page helpful?
Assistant
Responses are generated using AI and may contain mistakes.