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
  • YES: indicates that the queue table is secure.
  • NO: indicates that the queue table is not secure.