The USER_QUEUES view provides the information about a queue on which the current user has usage permissions.

Parameter Type Description
name TEXT The name of a queue.
queue_table TEXT The name of the queue table where the queue is located.
qid OID The system-assigned object ID 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 dequeuing attempts.
retrydelay NUMERIC The maximum time allowed between retries.
enqueue_enabled CHARACTER VARYING
  • YES: indicates that the queue allows enqueuing.
  • NO: indicates that the queue does not allow enqueuing.
dequeue_enabled CHARACTER VARYING
  • YES: indicates that the queue allows dequeuing.
  • NO: indicates that the queue does not allow dequeuing.
retention CHARACTER VARYING The number of seconds that a processed message is retained in the queue.
user_comment CHARACTER VARYING The user-defined comment.
network_name CHARACTER VARYING The name of the network where the queue is located.
sharded CHARACTER VARYING
  • YES: indicates the queue is on a sharded network.
  • NO: indicates the queue is not on a sharded network.