USER_QUEUES lists every queue on which the current user has usage privileges. Each row describes the operational characteristics of one queue: its type, retry policy, enqueue and dequeue status, message retention, and network placement.
Columns
| Column | Type | Description |
|---|---|---|
name | TEXT | The name of the queue. |
queue_table | TEXT | The name of the queue table where the queue is stored. |
qid | OID | The system-assigned object identifier of the queue. |
queue_type | CHARACTER VARYING | The type of the queue. Valid values: EXCEPTION_QUEUE, NON_PERSISTENT_QUEUE, and NORMAL_QUEUE. |
max_retries | NUMERIC | The maximum number of dequeue attempts. |
retrydelay | NUMERIC | The maximum time allowed between retry attempts. |
enqueue_enabled | CHARACTER VARYING | YES if the queue accepts enqueue operations; NO if enqueuing is disabled. |
dequeue_enabled | CHARACTER VARYING | YES if the queue accepts dequeue operations; NO if dequeuing is disabled. |
retention | CHARACTER VARYING | The number of seconds a processed message is retained in the queue. |
user_comment | CHARACTER VARYING | The user-defined comment associated with the queue. |
network_name | CHARACTER VARYING | The name of the network where the queue is located. |
sharded | CHARACTER VARYING | YES if the queue is on a sharded network; NO otherwise. |