Skip to main content

​
Syntax

SHOW SECRETS [ FROM schema_name ] [ LIKE_expression ];

​
Parameters

Parameter or clauseDescription
schema_nameThe schema of the secrets to be listed. If not specified, secrets from all schemas in the current schema search_path will be listed.
LIKE_expressionFilters 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.

Manage secrets

Learn about secret management

CREATE SECRET

Create a secret

DROP SECRET

Drop a secret