23.2. Retrieving Information About a Simple Secret (duckdb.show_simple_secret) #

Execute the following command:

  SELECT * FROM duckdb.show_simple_secret();

Postgres Pro AXE outputs the following columns:

Example 23.2. Calling the duckdb.show_simple_secret() function

  SELECT * FROM duckdb.show_simple_secret();

    secret_name    | secret_type |              options
  ------------------+-------------+-----------------------------------
  simple_s3_secret | S3          | region 'us-east-1', endpoint 'minio.example.com:9000'