13.3. Deleting a Simple Secret (duckdb.drop_simple_secret) #
You may need to delete a simple secret to update its parameters and then recreate it.
Required privileges: Postgres Pro AXE administrator only. For a full list of stored procedures and privileges, refer to Section 12.1.
Execute the following command on the Postgres Pro AXE server:
SELECT duckdb.drop_simple_secret('S3') ON CONFLICT DO NOTHING;
Postgres Pro AXE performs the following actions:
Deletes the foreign server and its user mapping:
DROP SERVER simple_s3_secret CASCADE;
Returns the name of the deleted simple secret.