ALL_QUEUES v16
The ALL_QUEUES view provides information about any currently defined queues.
| Name | Type | Description |
|---|---|---|
owner | TEXT | User name of the queue owner. |
name | TEXT | Name of the queue. |
queue_table | TEXT | Name of the queue table in which the queue resides. |
qid | OID | The system-assigned object ID of the queue. |
queue_type | CHARACTER VARYING | The queue type. Can be EXCEPTION_QUEUE, NON_PERSISTENT_QUEUE, or NORMAL_QUEUE. |
max_retries | NUMERIC | The maximum number of dequeue attempts. |
retrydelay | NUMERIC | The maximum time allowed between retries. |
enqueue_enabled | CHARACTER VARYING | YES if the queue allows enqueuing, NO if the queue does not. |
dequeue_enabled | CHARACTER VARYING | YES if the queue allows dequeuing, NO if the queue does not. |
retention | CHARACTER VARYING | The number of seconds that a processed message is retained in the queue. |
user_comment | CHARACTER VARYING | User-specified comment. |
network_name | CHARACTER VARYING | Name of the network on which the queue resides. |
sharded | CHARACTER VARYING | YES if the queue resides on a sharded network, NO if the queue does not. |