aws_sqs

Components

Tables

    queue

Code examples

Manage SQS

--- installs the SQS module
SELECT * FROM iasql_install('<modules>');
--- adds a new non-fifo queue
INSERT INTO queue (name, fifo_queue, region) -- use autogenerated policy
VALUES ('<prefix>', false, '<region>');
--- checks the queue still exists after commit
SELECT *
FROM queue
WHERE name = '<prefix>';
--- checks the fifo queue still exists after commit
SELECT *
FROM queue
WHERE name = '<prefix>.fifo';
--- moves the queue to non-default region
UPDATE queue
SET region = 'us-east-1'
WHERE name = '<prefix>.fifo';
--- deletes the queues
DELETE
FROM queue;