The USER_QUEUE_TABLES view provides the information about all of the queue tables accessible by the current user.
| Parameter | Type | Description |
|---|---|---|
| queue_table | TEXT | The user-defined name of the queue table. |
| type | CHARACTER VARYING | The type of data stored in the queue table. |
| object_type | TEXT | The user-defined payload type. |
| sort_order | CHARACTER VARYING | The order in which the queue table is sorted. |
| recipients | CHARACTER VARYING | The value is SINGLE. |
| message_grouping | CHARACTER VARYING | The value is NONE. |
| compatible | CHARACTER VARYING | The release number of the PolarDB for PostgreSQL(Compatible with Oracle). The queue table is compatible with this release. |
| primary_instance | NUMERIC | The value is 0. |
| secondary_instance | NUMERIC | The value is 0. |
| owner_instance | NUMERIC | The instance number of the instance to which the queue table belongs. |
| user_comment | CHARACTER VARYING | The comment added when the table was created. |
| secure | CHARACTER VARYING |
|