Syntax
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
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