USER_QUEUE_TABLES lists all queue tables accessible to the current user. Each row describes one queue table, including its data type, sort behavior, and security setting.
Columns
| Column | Type | Description |
|---|---|---|
queue_table | TEXT | User-defined name of the queue table. |
type | CHARACTER VARYING | Type of data stored in the queue table. |
object_type | TEXT | User-defined payload type. |
sort_order | CHARACTER VARYING | Order in which messages in the queue table are sorted. |
recipients | CHARACTER VARYING | Always SINGLE. |
message_grouping | CHARACTER VARYING | Always NONE. |
compatible | CHARACTER VARYING | The PolarDB for PostgreSQL(Compatible with Oracle) release that this queue table is compatible with. |
primary_instance | NUMERIC | Always 0. |
secondary_instance | NUMERIC | Always 0. |
owner_instance | NUMERIC | Instance number of the instance that owns the queue table. |
user_comment | CHARACTER VARYING | Comment added when the queue table was created. |
secure | CHARACTER VARYING | YES if the queue table is secure. NO if it is not. |