aws_sns

Components

Tables

    subscription

    topic

Functions

    confirm_subscription

    subscribe

    unsubscribe

Code examples

Manage SNS

--- installs the SNS module
SELECT * FROM iasql_install('<modules>');
--- adds a new topic
INSERT INTO topic (name)
VALUES ('<topicName>');
--- check adds a new topic
SELECT *
FROM topic
WHERE name = '<topicName>';
--- tries to update a field with an correct value
UPDATE topic SET tracing_config = 'PassThrough' WHERE name = '<topicName>';
--- check tracing config change has been applied
SELECT *
FROM topic
WHERE name = '<topicName>' AND tracing_config='PassThrough';
--- deletes the topic
DELETE FROM topic
WHERE name = '<topicName>';
--- check deletes the topic
SELECT *
FROM topic
WHERE name = '<topicName>';