USER_QUEUE_TABLES v16

The USER_QUEUE_TABLES view provides information about all of the queue tables the current user can access.

NameTypeDescription
queue_tableTEXTUser-specified name of the queue table.
typeCHARACTER VARYINGType of data stored in the queue table.
object_typeTEXTUser-defined payload type.
sort_orderCHARACTER VARYINGOrder in which the queue table is sorted.
recipientsCHARACTER VARYINGAlways SINGLE.
message_groupingCHARACTER VARYINGAlways NONE.
compatibleCHARACTER VARYINGRelease number of the EDB Postgres Advanced Server release with which this queue table is compatible.
primary_instanceNUMERICAlways 0.
secondary_instanceNUMERICAlways 0.
owner_instanceNUMERICInstance number of the instance that owns the queue table.
user_commentCHARACTER VARYINGUser comment provided when the table was created.
secureCHARACTER VARYINGYES indicates that the queue table is secure. NO indicates that it is not.