SHOW SECRETS

Use the SHOW SECRETS command to list all secrets in a schema.

Syntax

SHOW SECRETS [ FROM schema_name ] [ LIKE_expression ];

Parameters

Parameter or clause	Description
schema_name	The schema of the secrets to be listed. If not specified, secrets 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 SECRETS;

        Name
---------------------
 public.mysql_pwd
 public.kafka_token
(2 rows)

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

Related topics

Manage secrets

Learn about secret management

CREATE SECRET

Create a secret

DROP SECRET

Drop a secret