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:

ALTER QUEUE TABLE <name> RENAME TO <new_name>

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:

ALTER QUEUE TABLE wo_queue_east RENAME TO work_order_table;

See also

CREATE QUEUE TABLE, DROP QUEUE TABLE