The ALL_QUEUE_TABLES view provides the information about all queue tables in the database.
Parameter | Type | Description |
---|---|---|
owner | TEXT | The role name of the owner of a queue table. |
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 |
|