ALTER QUEUE TABLE v17
EDB Postgres Advanced Server includes extra syntax not offered by Oracle with the ALTER QUEUE SQL
command. You can use this syntax with the DBMS_AQADM
package.
Name
ALTER QUEUE TABLE
— Modify an existing queue table.
Synopsis
Use ALTER QUEUE TABLE
to change the name of an existing queue table:
Description
ALTER QUEUE TABLE
allows a superuser or a user with the aq_administrator_role
privilege to change the name of an existing queue table.
Parameters
name
The name (optionally schema-qualified) of an existing queue table.
new_name
New name for the queue table.
Examples
This example changes the name of a queue table from wo_table_east
to work_order_table
: