ALTER QUEUE TABLE v14

EDB Postgres Advanced Server includes extra syntax (not offered by Oracle) with the ALTER QUEUE SQL command. This syntax can be used in association 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

To change 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